Oct 3, 2022
Week #5 Agenda
Important: Update your local environment
import geopandas as gpd
import pandas as pd
import numpy as np
from shapely.geometry import Point
from matplotlib import pyplot as plt
import seaborn as sns
import hvplot.pandas
import holoviews as hv
# Show all columns
pd.options.display.max_columns = 999
Or, how to pull data from the web using Python
Example APIs
Note: when accessing data via API, many services will require you to register an API key to prevent you from overloading the service with requests
This is an API for near-real-time data about earthquakes, and data is provided in GeoJSON format over the web.
The API has a separate endpoint for each version of the data that users might want. No authentication is required.
API documentation:
http://earthquake.usgs.gov/earthquakes/feed/v1.0/geojson.php
Sample API endpoint, for magnitude 4.5+ earthquakes in past day:
http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/4.5_day.geojson
Note: GeoPandas can read GeoJSON from the web directly
Simply pass the URL to the gpd.read_file() function:
# Download data on magnitude 2.5+ quakes from the past week
endpoint_url = "http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_week.geojson"
df = gpd.read_file(endpoint_url)
df.head()
| id | mag | place | time | updated | tz | url | detail | felt | cdi | mmi | alert | status | tsunami | sig | net | code | ids | sources | types | nst | dmin | rms | gap | magType | type | title | geometry | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | us6000iqid | 5.20 | Reykjanes Ridge | 1664820502598 | 1664821283040 | None | https://earthquake.usgs.gov/earthquakes/eventp... | https://earthquake.usgs.gov/earthquakes/feed/v... | NaN | NaN | NaN | None | reviewed | 0 | 416 | us | 6000iqid | ,us6000iqid, | ,us, | ,origin,phase-data, | 68.0 | 9.10600 | 1.5100 | 52.00 | mb | earthquake | M 5.2 - Reykjanes Ridge | POINT Z (-35.50950 53.78860 10.00000) |
| 1 | ak022coqg5qq | 3.00 | 35 km NNW of Chenega, Alaska | 1664816402103 | 1664817258582 | None | https://earthquake.usgs.gov/earthquakes/eventp... | https://earthquake.usgs.gov/earthquakes/feed/v... | 1.0 | 2.0 | NaN | None | automatic | 0 | 139 | ak | 022coqg5qq | ,ak022coqg5qq, | ,ak, | ,dyfi,origin,phase-data, | NaN | NaN | 0.3600 | NaN | ml | earthquake | M 3.0 - 35 km NNW of Chenega, Alaska | POINT Z (-148.24140 60.36270 4.90000) |
| 2 | us6000iqfl | 4.40 | 50 km ENE of Mutsu, Japan | 1664815161466 | 1664817497040 | None | https://earthquake.usgs.gov/earthquakes/eventp... | https://earthquake.usgs.gov/earthquakes/feed/v... | NaN | NaN | NaN | None | reviewed | 0 | 298 | us | 6000iqfl | ,us6000iqfl, | ,us, | ,origin,phase-data, | 30.0 | 0.86600 | 0.3900 | 131.00 | mb | earthquake | M 4.4 - 50 km ENE of Mutsu, Japan | POINT Z (141.76760 41.47400 84.99000) |
| 3 | ci40355088 | 3.01 | 4km W of Banning, CA | 1664813289970 | 1664821582254 | None | https://earthquake.usgs.gov/earthquakes/eventp... | https://earthquake.usgs.gov/earthquakes/feed/v... | 98.0 | 3.1 | 3.537 | None | reviewed | 0 | 170 | ci | 40355088 | ,ci40355088,us6000iqfh, | ,ci,us, | ,dyfi,focal-mechanism,nearby-cities,origin,pha... | 114.0 | 0.04923 | 0.1700 | 20.00 | ml | earthquake | M 3.0 - 4km W of Banning, CA | POINT Z (-116.92150 33.92467 7.62000) |
| 4 | nn00848420 | 3.10 | Nevada | 1664810671035 | 1664812724040 | None | https://earthquake.usgs.gov/earthquakes/eventp... | https://earthquake.usgs.gov/earthquakes/feed/v... | NaN | NaN | NaN | None | reviewed | 0 | 148 | nn | 00848420 | ,us6000iqfb,nn00848420, | ,us,nn, | ,origin,phase-data, | 9.0 | 0.55200 | 0.1788 | 110.67 | ml | earthquake | M 3.1 - Nevada | POINT Z (-117.08790 40.82730 7.90000) |
Let's plot them on a map:
fig, ax = plt.subplots(figsize=(10, 10))
# plot the country outline
world = gpd.read_file(gpd.datasets.get_path("naturalearth_lowres"))
world.plot(ax=ax, facecolor="none", edgecolor="black")
# plot the earthquakes
df.plot(ax=ax, color="crimson", markersize=30, edgecolor='k', linewidth=0.5)
ax.set_axis_off()
A GeoService is a standardized format for returning GeoJSON files over the web.
Documentation http://geoservices.github.io/
OpenDataPhilly provides GeoService API endpoints for the geometry hosted on its platform
https://www.opendataphilly.org/dataset/zip-codes
# base URL
url = "https://services.arcgis.com/fLeGjb7u4uXqeF9q/arcgis/rest/services/Zipcodes_Poly/FeatureServer/0/"
esri2gpd¶https://github.com/PhiladelphiaController/esri2gpd
import esri2gpd
zip_codes = esri2gpd.get(url)
zip_codes.head()
| geometry | OBJECTID | CODE | COD | Shape__Area | Shape__Length | |
|---|---|---|---|---|---|---|
| 0 | POLYGON ((-75.11107 40.04682, -75.11206 40.047... | 1 | 19120 | 20 | 9.177970e+07 | 49921.544063 |
| 1 | POLYGON ((-75.19227 39.99463, -75.19240 39.994... | 2 | 19121 | 21 | 6.959879e+07 | 39534.887217 |
| 2 | POLYGON ((-75.15406 39.98601, -75.15494 39.986... | 3 | 19122 | 22 | 3.591632e+07 | 24124.645221 |
| 3 | POLYGON ((-75.15190 39.97056, -75.15258 39.970... | 4 | 19123 | 23 | 3.585175e+07 | 26421.728982 |
| 4 | POLYGON ((-75.09660 40.04249, -75.09661 40.042... | 5 | 19124 | 24 | 1.448080e+08 | 63658.770420 |
zip_codes.crs
<Geographic 2D CRS: EPSG:4326> Name: WGS 84 Axis Info [ellipsoidal]: - Lat[north]: Geodetic latitude (degree) - Lon[east]: Geodetic longitude (degree) Area of Use: - name: World. - bounds: (-180.0, -90.0, 180.0, 90.0) Datum: World Geodetic System 1984 ensemble - Ellipsoid: WGS 84 - Prime Meridian: Greenwich
Let's plot it
fig, ax = plt.subplots(figsize=(6, 6))
zip_codes.to_crs(epsg=3857).plot(ax=ax, facecolor="none", edgecolor="black")
ax.set_axis_off()
https://www.opendataphilly.org/dataset/census-tracts
Note: the "API documentation" on OpenDataPhilly will link to the documentation for the CARTO database
For example: shooting victims in Philadelphia
https://www.opendataphilly.org/dataset/shooting-victims
Download link on Open Data Philly is just querying an API!
https://phl.carto.com/api/v2/sql?q=SELECT+*,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+shootings&filename=shootings&format=csv&skipfields=cartodb_id
The CARTO databases can be queried using SQL. This allows you to select specific data from the larger database.
CARTO API documentation: https://carto.com/developers/sql-api/
SQL documentation: https://www.postgresql.org/docs/9.1/sql.html
SELECT [field names] FROM [table name] WHERE [query]
We'll use Python's requests library to query the API endpoint with our desired query.
import requests
# the API end point
API_endpoint = "https://phl.carto.com/api/v2/sql"
# the query
query = "SELECT * FROM shootings" # table name is "shootings"
# desired format of the returned features
output_format = 'geojson'
# fields to skip
skipfields = ["cartodb_id"]
# all of our request parameters
params = dict(q=query, format=output_format, skipfields=skipfields)
params
{'q': 'SELECT * FROM shootings',
'format': 'geojson',
'skipfields': ['cartodb_id']}
# make the request
r = requests.get(API_endpoint, params=params)
r
<Response [200]>
# Get the returned data in JSON format
# This is a dictionary
features = r.json()
type(features)
dict
# What are the keys?
list(features.keys())
['type', 'features']
features['type']
'FeatureCollection'
# Let's look at the first feature
features['features'][0]
{'type': 'Feature',
'geometry': {'type': 'Point', 'coordinates': [-75.119383, 39.98878]},
'properties': {'objectid': 5419571,
'year': 2020,
'dc_key': '202024002926.0',
'code': '111',
'date_': '2020-01-11T00:00:00Z',
'time': '23:37:00',
'race': 'B',
'sex': 'M',
'age': '23',
'wound': 'Multiple',
'officer_involved': 'N',
'offender_injured': 'N',
'offender_deceased': 'N',
'location': '2000 BLOCK E Rush St',
'latino': 0,
'point_x': None,
'point_y': None,
'dist': '24',
'inside': 0,
'outside': 1,
'fatal': 1}}
Use the GeoDataFrame.from_features() function to create a GeoDataFrame.
Don't forget to specify the CRS of the input data!
shootings = gpd.GeoDataFrame.from_features(features, crs="EPSG:4326")
shootings.head()
| geometry | objectid | year | dc_key | code | date_ | time | race | sex | age | wound | officer_involved | offender_injured | offender_deceased | location | latino | point_x | point_y | dist | inside | outside | fatal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POINT (-75.11938 39.98878) | 5419571 | 2020 | 202024002926.0 | 111 | 2020-01-11T00:00:00Z | 23:37:00 | B | M | 23 | Multiple | N | N | N | 2000 BLOCK E Rush St | 0.0 | NaN | NaN | 24 | 0.0 | 1.0 | 1.0 |
| 1 | POINT (-75.12721 39.99508) | 5419572 | 2020 | 202024003147.0 | 411 | 2020-01-12T00:00:00Z | 20:44:00 | B | M | 30 | Leg | N | N | N | 200 BLOCK E Indiana St | 1.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 |
| 2 | POINT (-75.12721 39.99508) | 5419573 | 2020 | 202024003157.0 | 411 | 2020-01-12T00:00:00Z | 20:44:00 | W | M | 24 | Hand | N | N | N | 200 BLOCK E Indiana St | 1.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 |
| 3 | POINT (-75.12568 39.99644) | 5419574 | 2020 | 202024004335.0 | 300 | 2020-01-16T00:00:00Z | 18:45:00 | W | M | 57 | Arm | N | N | N | 300 BLOCK E Clearfield St | 1.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 |
| 4 | POINT (-75.12768 39.99779) | 5419575 | 2020 | 202024004603.0 | 411 | 2020-01-17T00:00:00Z | 19:30:00 | B | M | 30 | Stomach | N | N | N | 100 BLOCK E Wishart St | 0.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 |
A quick plot with geopandas to show the shootings as points
The COUNT function can be applied to count all rows.
query = "SELECT COUNT(*) FROM shootings"
params = dict(q=query)
r = requests.get(API_endpoint, params=params)
r.json()
{'rows': [{'cartodb_id': 1,
'the_geom': '0101000020E6100000DC40AAF6A3C752C06318665790FE4340',
'the_geom_webmercator': '0101000020110F0000828A6FDA42E65FC123F590FC4D8E5241',
'objectid': 5419571,
'year': 2020,
'dc_key': '202024002926.0',
'code': '111',
'date_': '2020-01-11T00:00:00Z',
'time': '23:37:00',
'race': 'B',
'sex': 'M',
'age': '23',
'wound': 'Multiple',
'officer_involved': 'N',
'offender_injured': 'N',
'offender_deceased': 'N',
'location': '2000 BLOCK E Rush St',
'latino': 0,
'point_x': None,
'point_y': None,
'dist': '24',
'inside': 0,
'outside': 1,
'fatal': 1}],
'time': 0.002,
'fields': {'cartodb_id': {'type': 'number', 'pgtype': 'int8'},
'the_geom': {'type': 'geometry',
'wkbtype': 'Unknown',
'dims': 2,
'srid': 4326},
'the_geom_webmercator': {'type': 'geometry',
'wkbtype': 'Unknown',
'dims': 2,
'srid': 3857},
'objectid': {'type': 'number', 'pgtype': 'numeric'},
'year': {'type': 'number', 'pgtype': 'numeric'},
'dc_key': {'type': 'string', 'pgtype': 'text'},
'code': {'type': 'string', 'pgtype': 'text'},
'date_': {'type': 'date', 'pgtype': 'date'},
'time': {'type': 'string', 'pgtype': 'text'},
'race': {'type': 'string', 'pgtype': 'text'},
'sex': {'type': 'string', 'pgtype': 'text'},
'age': {'type': 'string', 'pgtype': 'text'},
'wound': {'type': 'string', 'pgtype': 'text'},
'officer_involved': {'type': 'string', 'pgtype': 'text'},
'offender_injured': {'type': 'string', 'pgtype': 'text'},
'offender_deceased': {'type': 'string', 'pgtype': 'text'},
'location': {'type': 'string', 'pgtype': 'text'},
'latino': {'type': 'number', 'pgtype': 'numeric'},
'point_x': {'type': 'number', 'pgtype': 'numeric'},
'point_y': {'type': 'number', 'pgtype': 'numeric'},
'dist': {'type': 'string', 'pgtype': 'text'},
'inside': {'type': 'number', 'pgtype': 'numeric'},
'outside': {'type': 'number', 'pgtype': 'numeric'},
'fatal': {'type': 'number', 'pgtype': 'numeric'}},
'total_rows': 1}
Important: always good to check how many rows you might be downloading before hand.
The LIMIT function limits the number of returned rows. It is very useful for taking a quick look at the format of a database.
# select the first 5
query = "SELECT * FROM shootings LIMIT 1"
params = dict(q=query, format="geojson")
r = requests.get(API_endpoint, params=params)
df = gpd.GeoDataFrame.from_features(r.json(), crs="EPSG:4326")
df
| geometry | cartodb_id | objectid | year | dc_key | code | date_ | time | race | sex | age | wound | officer_involved | offender_injured | offender_deceased | location | latino | point_x | point_y | dist | inside | outside | fatal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POINT (-75.11938 39.98878) | 1 | 5419571 | 2020 | 202024002926.0 | 111 | 2020-01-11T00:00:00Z | 23:37:00 | B | M | 23 | Multiple | N | N | N | 2000 BLOCK E Rush St | 0 | None | None | 24 | 0 | 1 | 1 |
shootings.head()
| geometry | objectid | year | dc_key | code | date_ | time | race | sex | age | wound | officer_involved | offender_injured | offender_deceased | location | latino | point_x | point_y | dist | inside | outside | fatal | OBJECTID | Shape__Area | Shape__Length | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POINT (-8362251.464 4864311.954) | 5419571 | 2020 | 202024002926.0 | 111 | 2020-01-11T00:00:00Z | 23:37:00 | B | M | 23 | Multiple | N | N | N | 2000 BLOCK E Rush St | 0.0 | NaN | NaN | 24 | 0.0 | 1.0 | 1.0 | 1 | 3.970706e+09 | 394751.12047 |
| 1 | POINT (-8363122.205 4865227.054) | 5419572 | 2020 | 202024003147.0 | 411 | 2020-01-12T00:00:00Z | 20:44:00 | B | M | 30 | Leg | N | N | N | 200 BLOCK E Indiana St | 1.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 | 1 | 3.970706e+09 | 394751.12047 |
| 2 | POINT (-8363122.205 4865227.054) | 5419573 | 2020 | 202024003157.0 | 411 | 2020-01-12T00:00:00Z | 20:44:00 | W | M | 24 | Hand | N | N | N | 200 BLOCK E Indiana St | 1.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 | 1 | 3.970706e+09 | 394751.12047 |
| 3 | POINT (-8362952.777 4865424.818) | 5419574 | 2020 | 202024004335.0 | 300 | 2020-01-16T00:00:00Z | 18:45:00 | W | M | 57 | Arm | N | N | N | 300 BLOCK E Clearfield St | 1.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 | 1 | 3.970706e+09 | 394751.12047 |
| 4 | POINT (-8363175.639 4865620.407) | 5419575 | 2020 | 202024004603.0 | 411 | 2020-01-17T00:00:00Z | 19:30:00 | B | M | 30 | Stomach | N | N | N | 100 BLOCK E Wishart St | 0.0 | NaN | NaN | 24 | 0.0 | 1.0 | 0.0 | 1 | 3.970706e+09 | 394751.12047 |
Select nonfatal shootings only
query = "SELECT * FROM shootings WHERE fatal = 0"
# Make the request
params = dict(q=query, format="geojson")
r = requests.get(API_endpoint, params=params)
# Make the GeoDataFrame
fatal = gpd.GeoDataFrame.from_features(r.json(), crs="EPSG:4326")
print("number of nonfatal shootings = ", len(fatal))
number of nonfatal shootings = 10434
Select shootings in 2022
query = "SELECT * FROM shootings WHERE date_ > '12/31/21'"
# Make the request
params = dict(q=query, format="geojson")
r = requests.get(API_endpoint, params=params)
# Make the GeoDataFrame
this_year = gpd.GeoDataFrame.from_features(r.json(), crs="EPSG:4326")
print("number of shootings this year = ", len(this_year))
number of shootings this year = 1822
carto2gpd¶get() function will query the databaseget_size() function will use COUNT() to get the total number of rowshttps://github.com/PhiladelphiaController/carto2gpd
import carto2gpd
where = "date_ > '12/31/21' and fatal = 0"
df = carto2gpd.get(API_endpoint, 'shootings', where=where)
df.head()
| geometry | cartodb_id | objectid | year | dc_key | code | date_ | time | race | sex | age | wound | officer_involved | offender_injured | offender_deceased | location | latino | point_x | point_y | dist | inside | outside | fatal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POINT (-75.15220 39.93557) | 8151 | 5422916 | 2022 | 202203023589.0 | 401 | 2022-06-13T00:00:00Z | 11:55:00 | B | F | 24 | Head | N | N | N | 1000 BLOCK S 5TH ST | 0 | None | None | 3 | 0 | 1 | 0 |
| 1 | POINT (-75.15144 39.93129) | 8432 | 5422917 | 2022 | 202203024090.0 | 401 | 2022-06-16T00:00:00Z | 14:56:00 | W | M | 31 | Hand | N | N | N | 1300 BLOCK S 4TH ST | 0 | None | None | 3 | 0 | 1 | 0 |
| 2 | POINT (-75.21666 39.93809) | 8537 | 5423021 | 2022 | 202212010701.0 | 401 | 2022-02-26T00:00:00Z | 17:49:00 | B | F | 32 | Ankle | N | N | N | 5200 BLOCK WOODLAND AVE | 0 | None | None | 12 | 0 | 1 | 0 |
| 3 | POINT (-75.22222 39.93632) | 8538 | 5423022 | 2022 | 202212012893.0 | 401 | 2022-03-09T00:00:00Z | 23:14:00 | B | M | 44 | Shoulder | N | N | N | 5500 BLOCK GREENWAY AVE | 0 | None | None | 12 | 0 | 1 | 0 |
| 4 | POINT (-75.23698 39.94334) | 8539 | 5423023 | 2022 | 202212013020.0 | 401 | 2022-03-10T00:00:00Z | 18:14:00 | B | M | 25 | Multiple | N | N | N | 5700 BLOCK ASHLAND AVE | 0 | None | None | 12 | 0 | 1 | 0 |
# Limit results to the first 5
df = carto2gpd.get(API_endpoint, 'shootings', limit=5)
len(df)
5
df
| geometry | cartodb_id | objectid | year | dc_key | code | date_ | time | race | sex | age | wound | officer_involved | offender_injured | offender_deceased | location | latino | point_x | point_y | dist | inside | outside | fatal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POINT (-75.11938 39.98878) | 1 | 5419571 | 2020 | 202024002926.0 | 111 | 2020-01-11T00:00:00Z | 23:37:00 | B | M | 23 | Multiple | N | N | N | 2000 BLOCK E Rush St | 0 | None | None | 24 | 0 | 1 | 1 |
| 1 | POINT (-75.12721 39.99508) | 2 | 5419572 | 2020 | 202024003147.0 | 411 | 2020-01-12T00:00:00Z | 20:44:00 | B | M | 30 | Leg | N | N | N | 200 BLOCK E Indiana St | 1 | None | None | 24 | 0 | 1 | 0 |
| 2 | POINT (-75.12721 39.99508) | 3 | 5419573 | 2020 | 202024003157.0 | 411 | 2020-01-12T00:00:00Z | 20:44:00 | W | M | 24 | Hand | N | N | N | 200 BLOCK E Indiana St | 1 | None | None | 24 | 0 | 1 | 0 |
| 3 | POINT (-75.12568 39.99644) | 4 | 5419574 | 2020 | 202024004335.0 | 300 | 2020-01-16T00:00:00Z | 18:45:00 | W | M | 57 | Arm | N | N | N | 300 BLOCK E Clearfield St | 1 | None | None | 24 | 0 | 1 | 0 |
| 4 | POINT (-75.12768 39.99779) | 5 | 5419575 | 2020 | 202024004603.0 | 411 | 2020-01-17T00:00:00Z | 19:30:00 | B | M | 30 | Stomach | N | N | N | 100 BLOCK E Wishart St | 0 | None | None | 24 | 0 | 1 | 0 |
size = carto2gpd.get_size(API_endpoint, 'shootings')
print(size)
13241
DateTime objects¶Add Month and Day of Week columns
Use the familiar Groupby --> size()
hvplot¶
Several 3rd party options with easier interfaces for accessing census data
https://api.census.gov/data/2021/acs/acs1?get=NAME,B17001_002E&for=state:*
The census provides web-based documentation:
https://www.census.gov/data/developers/guidance/api-user-guide.html
Several packages provide easier Python interfaces to census data based on the census API.
We'll focus on cenpy - "Explore and download data from Census APIs"
Let's make this for Philadelphia in Python!
# First step: import cenpy
import cenpy
Functions to help you explore the Census API from Python
cenpy.explorer.available: Returns information about available datasets in Census APIcenpy.explorer.explain: Explain a specific Census datasetcenpy.explorer.fips_table: Get a table of FIPS codes for a specific geographyNote: we can change pandas display options to see all rows/columns and large cells
# UNCOMMENT TO SEE ALL ROWS/COLUMNS IN DATAFRAMES
pd.options.display.max_rows = 999
pd.options.display.max_colwidth = 200
available = cenpy.explorer.available()
available.head()
| c_isTimeseries | c_isMicrodata | publisher | temporal | spatial | programCode | modified | keyword | contactPoint | distribution | description | bureauCode | accessLevel | title | c_isAvailable | c_isCube | c_isAggregate | c_dataset | vintage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ABSCB2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:007 | 2020-04-30 00:00:00.0 | (census,) | {'fn': 'ASE Staff', 'hasEmail': 'mailto:erd.annual.survey.of.entrepreneurs@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/abscb', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Annual Business Survey (ABS) provides information on selected economic and demographic characteristics for businesses and business owners by sex, ethnicity, race, and veteran status. Further, ... | 006:07 | public | Economic Surveys: Annual Business Survey: Annual Business Survey | True | NaN | True | (abscb,) | 2017.0 |
| ABSCB2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:007 | 2020-10-26 00:00:00.0 | (census,) | {'fn': 'ASE Staff', 'hasEmail': 'mailto:Erd.annual.survey.of.entrepreneurs@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/abscb', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Annual Business Survey (ABS) provides information on selected economic and demographic characteristics for businesses and business owners by sex, ethnicity, race, and veteran status. Further, ... | 006:07 | public | Economic Surveys: Annual Business Survey: Annual Business Survey | True | NaN | True | (abscb,) | 2018.0 |
| ABSCB2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:007 | 2021-08-17 00:00:00.0 | (census,) | {'fn': 'ASE Staff', 'hasEmail': 'mailto:ERD.annual.survey.of.entrepreneurs@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/abscb', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Annual Business Survey (ABS) provides information on selected economic and demographic characteristics for businesses and business owners by sex, ethnicity, race, and veteran status. Further, ... | 006:07 | public | Economic Surveys: Annual Business Survey: Annual Business Survey | True | NaN | True | (abscb,) | 2019.0 |
| ABSCBO2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:007 | 2020-04-30 00:00:00.0 | (census,) | {'fn': 'ASE Staff', 'hasEmail': 'mailto:erd.annual.survey.of.entrepreneurs@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/abscbo', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Annual Business Survey (ABS) provides information on selected economic and demographic characteristics for businesses and business owners by sex, ethnicity, race, and veteran status. Further, ... | 006:07 | public | Economic Surveys: Annual Business Survey: Annual Business Survey | True | NaN | True | (abscbo,) | 2017.0 |
| ABSCBO2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:007 | 2020-10-26 00:00:00.0 | (census,) | {'fn': 'ASE Staff', 'hasEmail': 'mailto:erd.annual.survey.of.entrepreneurs@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/abscbo', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Annual Business Survey (ABS) provides information on selected economic and demographic characteristics for businesses and business owners by sex, ethnicity, race, and veteran status. Further, ... | 006:07 | public | Economic Surveys: Annual Business Survey: Annual Business Survey | True | NaN | True | (abscbo,) | 2018.0 |
We can use the pandas filter() to search for specific identifiers in the dataframe.
In this case, let's search for the American Community Survey datasets. We'll match index labels using regular expressions.
In particular, we'll search for labels that start with "ACS". In the language of regular expressions, we'll use the "^" to mean "match labels that start with"
For more info on regular expressions, the documentation for the re module is a good place to start.
# Return a dataframe of all datasets that start with "ACS"
# Axis=0 means to filter the index labels!
acs = available.filter(regex="^ACS", axis=0)
acs
| c_isTimeseries | c_isMicrodata | publisher | temporal | spatial | programCode | modified | keyword | contactPoint | distribution | description | bureauCode | accessLevel | title | c_isAvailable | c_isCube | c_isAggregate | c_dataset | vintage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACSCD1132011 | NaN | NaN | U.S. Census Bureau | 2011/2011 | United States | 006:004 | 2014-10-06 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs1/cd113', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | 2011 American Community Survey 1-Year Profiles for the 113th Congressional Districts | True | NaN | True | (acs1, cd113) | 2011.0 |
| ACSCD1152015 | NaN | NaN | U.S. Census Bureau | 2015/2015 | United States | 006:004 | 2017-02-10 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs1/cd115', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | 2015 American Community Survey 1-Year Data Profile 115th Congressional District | True | NaN | True | (acs1, cd115) | 2015.0 |
| ACSCP1Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-09-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2010.0 |
| ACSCP1Y2011 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-09-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2011.0 |
| ACSCP1Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2012.0 |
| ACSCP1Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2013.0 |
| ACSCP1Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2014.0 |
| ACSCP1Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2015.0 |
| ACSCP1Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2016.0 |
| ACSCP1Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-09-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Comparison Profiles | True | True | True | (acs, acs1, cprofile) | 2017.0 |
| ACSCP1Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-07-15 09:36:24.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Comparison Profiles 1-Year | True | True | True | (acs, acs1, cprofile) | 2018.0 |
| ACSCP1Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Comparison Profiles 1-Year | True | True | True | (acs, acs1, cprofile) | 2019.0 |
| ACSCP1Y2021 | NaN | NaN | U.S. Census Bureau | 2021/2021 | US | 006:004 | 2022-04-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2021/acs/acs1/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Comparison Profiles 1-Year | True | True | True | (acs, acs1, cprofile) | 2021.0 |
| ACSCP3Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-03 09:25:46.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs3/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Comparison Profiles 3-Year | True | True | True | (acs, acs3, cprofile) | 2012.0 |
| ACSCP3Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs3/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Comparison Profiles 3-Year | True | True | True | (acs, acs3, cprofile) | 2013.0 |
| ACSCP5Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Comparison Profiles | True | True | True | (acs, acs5, cprofile) | 2015.0 |
| ACSCP5Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Comparison Profiles | True | True | True | (acs, acs5, cprofile) | 2016.0 |
| ACSCP5Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-10-19 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Comparison Profiles | True | True | True | (acs, acs5, cprofile) | 2017.0 |
| ACSCP5Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-22 14:54:09.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Comparison Profiles 5-Year | True | True | True | (acs, acs5, cprofile) | 2018.0 |
| ACSCP5Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Comparison Profiles 5-Year | True | True | True | (acs, acs5, cprofile) | 2019.0 |
| ACSCP5Y2020 | NaN | NaN | U.S. Census Bureau | 2020/2020 | US | 006:004 | 2021-07-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5/cprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endp... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Comparison Profiles 5-Year | True | True | True | (acs, acs5, cprofile) | 2020.0 |
| ACSDP1Y2005 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 09:56:34.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2005/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2005.0 |
| ACSDP1Y2006 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 09:40:51.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2006/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2006.0 |
| ACSDP1Y2007 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 09:13:41.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2007/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2007.0 |
| ACSDP1Y2008 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 08:38:11.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2008.0 |
| ACSDP1Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 12:22:20.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2009.0 |
| ACSDP1Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2010.0 |
| ACSDP1Y2011 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2011.0 |
| ACSDP1Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2012.0 |
| ACSDP1Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-02 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2013.0 |
| ACSDP1Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2014.0 |
| ACSDP1Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2015.0 |
| ACSDP1Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2016.0 |
| ACSDP1Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-09-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Data Profiles | True | True | True | (acs, acs1, profile) | 2017.0 |
| ACSDP1Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-06-25 15:57:43.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | ACS 1-Year Profile Tables | True | True | True | (acs, acs1, profile) | 2018.0 |
| ACSDP1Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a uswide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2019.0 |
| ACSDP1Y2021 | NaN | NaN | U.S. Census Bureau | 2021/2021 | US | 006:004 | 2022-04-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2021/acs/acs1/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a US-wide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafte... | 006:07 | public | American Community Survey: 1-Year Estimates: Data Profiles 1-Year | True | True | True | (acs, acs1, profile) | 2021.0 |
| ACSDP3Y2007 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 09:03:27.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2007/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2007.0 |
| ACSDP3Y2008 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-28 13:38:57.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2008.0 |
| ACSDP3Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-09 06:43:35.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2009.0 |
| ACSDP3Y2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-28 09:44:53.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2010.0 |
| ACSDP3Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-28 13:45:30.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2011.0 |
| ACSDP3Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-28 15:14:18.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2012.0 |
| ACSDP3Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-28 15:59:11.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs3/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Data Profiles 3-Year | True | True | True | (acs, acs3, profile) | 2013.0 |
| ACSDP5Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 10:36:01.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Data Profiles 5-Year | True | True | True | (acs, acs5, profile) | 2009.0 |
| ACSDP5Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2010.0 |
| ACSDP5Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2011.0 |
| ACSDP5Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2012.0 |
| ACSDP5Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2013.0 |
| ACSDP5Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2014.0 |
| ACSDP5Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2015.0 |
| ACSDP5Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2016.0 |
| ACSDP5Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-10-19 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2017.0 |
| ACSDP5Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-22 16:22:18.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Data Profiles | True | True | True | (acs, acs5, profile) | 2018.0 |
| ACSDP5Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Data Profiles 5-Year | True | True | True | (acs, acs5, profile) | 2019.0 |
| ACSDP5Y2020 | NaN | NaN | U.S. Census Bureau | 2020/2020 | US | 006:004 | 2021-07-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5/profile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Data Profiles 5-Year | True | True | True | (acs, acs5, profile) | 2020.0 |
| ACSDP5YAIAN2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-24 06:46:02.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/aianprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API e... | The American Indian and Alaska Native (AIAN) tables are released every five years. They are available for selected tribal populations, with more detailed tribal categories compared to those in the... | 006:07 | public | American Community Survey: 5-Year Estimates: American Indian and Alaska Native Data Profiles 5-Year | True | True | True | (acs, acs5, aianprofile) | 2010.0 |
| ACSDP5YAIAN2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-11 08:52:59.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/aianprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API e... | The American Indian and Alaska Native (AIAN) tables are released every five years. They are available for selected tribal populations, with more detailed tribal categories compared to those in the... | 006:07 | public | American Community Survey: 5-Year Estimates: American Indian and Alaska Native Data Profiles 5-Year | True | True | True | (acs, acs5, aianprofile) | 2015.0 |
| ACSDP5YSPT2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-09 13:54:45.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/sptprofile', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API en... | The Selected Population Tables (SPT) are released every five years. They are available for selected race, Hispanic origin, tribal, and ancestry populations. | 006:07 | public | American Community Survey: 5-Year Estimates: Selected Population Data Profiles 5-Year | True | True | True | (acs, acs5, sptprofile) | 2010.0 |
| ACSDT1Y2005 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 12:50:06.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2005/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2005.0 |
| ACSDT1Y2006 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 10:47:47.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2006/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2006.0 |
| ACSDT1Y2007 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 10:05:20.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2007/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2007.0 |
| ACSDT1Y2008 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 07:30:33.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2008.0 |
| ACSDT1Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-26 10:52:39.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2009.0 |
| ACSDT1Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2010.0 |
| ACSDT1Y2011 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2011.0 |
| ACSDT1Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2012.0 |
| ACSDT1Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2013.0 |
| ACSDT1Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2014.0 |
| ACSDT1Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2021-03-24 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2015.0 |
| ACSDT1Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2016.0 |
| ACSDT1Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-09-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Detailed Tables | True | True | True | (acs, acs1) | 2017.0 |
| ACSDT1Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-06-25 15:57:36.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2018.0 |
| ACSDT1Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2019.0 |
| ACSDT1Y2021 | NaN | NaN | U.S. Census Bureau | 2021/2021 | US | 006:004 | 2022-04-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2021/acs/acs1', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Detailed Tables 1-Year | True | True | True | (acs, acs1) | 2021.0 |
| ACSDT3Y2007 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-29 09:23:35.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2007/acs/acs3', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Detailed Tables 3-Year | True | True | True | (acs, acs3) | 2007.0 |
| ACSDT3Y2008 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-28 09:07:18.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs3', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Detailed Tables 3-Year | True | True | True | (acs, acs3) | 2008.0 |
| ACSDT3Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-08 07:27:05.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs3', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Detailed Tables 3-Year | True | True | True | (acs, acs3) | 2009.0 |
| ACSDT3Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-30 14:14:31.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs3', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Detailed Tables 3-Year | True | True | True | (acs, acs3) | 2011.0 |
| ACSDT3Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-31 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs3', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Detailed Tables 3-Year | True | True | True | (acs, acs3) | 2012.0 |
| ACSDT3Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-01-31 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs3', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: 3-Year Estimates: Detailed Tables 3-Year | True | True | True | (acs, acs3) | 2013.0 |
| ACSDT5Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 13:11:18.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2009.0 |
| ACSDT5Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2010.0 |
| ACSDT5Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2011.0 |
| ACSDT5Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2012.0 |
| ACSDT5Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2013.0 |
| ACSDT5Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2014.0 |
| ACSDT5Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2015.0 |
| ACSDT5Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2016.0 |
| ACSDT5Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-08-21 07:11:43.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2017.0 |
| ACSDT5Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-22 16:28:02.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2018.0 |
| ACSDT5Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2019.0 |
| ACSDT5Y2020 | NaN | NaN | U.S. Census Bureau | 2020/2020 | US | 006:004 | 2021-07-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2020.0 |
| ACSDT5YAIAN2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-24 07:18:57.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/aian', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Indian and Alaska Native (AIAN) tables are released every five years. They are available for selected tribal populations, with more detailed tribal categories compared to those in the... | 006:07 | public | American Community Survey: 5-Year Estimates: American Indian and Alaska Native Detailed Tables 5-Year | True | True | True | (acs, acs5, aian) | 2010.0 |
| ACSDT5YAIAN2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/aian', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Indian and Alaska Native (AIAN) tables are released every five years. They are available for selected tribal populations, with more detailed tribal categories compared to those in the... | 006:07 | public | ACS 5-Year AIAN Detailed Tables | True | True | True | (acs, acs5, aian) | 2015.0 |
| ACSDT5YSPT2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-11 14:16:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/spt', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Selected Population Tables (SPT) are released every five years. They are available for selected race, Hispanic origin, tribal, and ancestry populations. | 006:07 | public | American Community Survey: 5-Year Estimates: Selected Population Detailed Tables 5-Year | True | True | True | (acs, acs5, spt) | 2010.0 |
| ACSDT5YSPT2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/spt', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Selected Population Tables (SPT) are released every five years. They are available for selected race, Hispanic origin, tribal, and ancestry populations. | 006:07 | public | American Community Survey: 5-Year Estimates: Selected Population Detailed Tables 5-Year | True | True | True | (acs, acs5, spt) | 2015.0 |
| ACSEEO5Y2018 | NaN | NaN | U.S. Census Bureau | 2018/2018 | NaN | 006:004 | 2021-07-28 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5/eeo', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Equal Employment Opportunity Tabulation (5-year ACS data) | 006:07 | public | American Community Survey: 5-Year Estimates: Equal Employment Opportunity 5-Year | True | True | True | (acs, acs5, eeo) | 2018.0 |
| ACSFLOWS2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-10-10 00:00:00.0 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | ACS FLOWS | True | True | True | (acs, flows) | 2016.0 |
| ACSFLOWS2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-20 10:12:55.0 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | ACS FLOWS | True | True | True | (acs, flows) | 2017.0 |
| ACSFLOWS2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-07 00:00:00.0 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2014-2018 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2018.0 |
| ACSFLOWS2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2021-04-29 00:00:00.0 | (census,) | {'fn': 'Journey-to-Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2015-2019 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2019.0 |
| ACSFlows2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-08-22 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2006-2010 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2010.0 |
| ACSFlows2011 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-08-22 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2007-2011 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2011.0 |
| ACSFlows2012 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-08-22 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2008-2012 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2012.0 |
| ACSFlows2013 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-08-22 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2009-2013 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2013.0 |
| ACSFlows2014 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-08-22 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2010-2014 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2014.0 |
| ACSFlows2015 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-08-22 | (census,) | {'fn': 'Journey to Work and Migration Statistics Branch', 'hasEmail': 'mailto:sehsd.migration@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/flows', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Migration flows are derived from the relationship between the location of current residence in the American Community Survey (ACS) sample and the responses given to the migration question "Where d... | 006:07 | public | 2011-2015 American Community Survey: Migration Flows | True | NaN | True | (acs, flows) | 2015.0 |
| ACSLANG5Y2013 | NaN | NaN | U.S. Census Bureau | 2013/2013 | United States | 006:004 | 2015-09-02 | (census,) | {'fn': 'Education and Social Stratification Branch', 'hasEmail': 'mailto:dsd.ferrett@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/language', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | This data set uses the 2009-2013 American Community Survey to tabulate the number of speakers of languages spoken at home and the number of speakers of each language who speak English less than ve... | 006:07 | public | 2013 American Community Survey - Table Packages: Detailed Language Spoken in the U.S. | True | NaN | True | (language,) | 2013.0 |
| ACSPUMS1Y2004 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:50:36.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2004/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2004 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2004.0 |
| ACSPUMS1Y2005 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:51:37.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2005/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2005 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2005.0 |
| ACSPUMS1Y2006 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:51:41.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2006/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2006 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2006.0 |
| ACSPUMS1Y2007 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:51:46.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2007/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2007 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2007.0 |
| ACSPUMS1Y2008 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:51:53.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2008 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2008.0 |
| ACSPUMS1Y2009 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:51:57.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2009 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2009.0 |
| ACSPUMS1Y2010 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:01.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2010 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2010.0 |
| ACSPUMS1Y2011 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:05.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2011 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2011.0 |
| ACSPUMS1Y2012 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:11.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2012 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2012.0 |
| ACSPUMS1Y2013 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:15.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2013 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2013.0 |
| ACSPUMS1Y2014 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:19.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2014 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2014.0 |
| ACSPUMS1Y2015 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:23.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2015 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2015.0 |
| ACSPUMS1Y2016 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:27.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2016 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2016.0 |
| ACSPUMS1Y2017 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:31.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2017 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2017.0 |
| ACSPUMS1Y2018 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 10:52:35.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2018 American Community Survey: 1-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs1, pums) | 2018.0 |
| ACSPUMS1Y2019 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-06-16 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | ACS 1-Year PUMS | True | True | NaN | (acs, acs1, pums) | 2019.0 |
| ACSPUMS1YPR2005 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:58:26.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2005/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2005 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2005.0 |
| ACSPUMS1YPR2006 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:58:45.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2006/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2006 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2006.0 |
| ACSPUMS1YPR2007 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:58:49.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2007/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2007 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2007.0 |
| ACSPUMS1YPR2008 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:58:54.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2008 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2008.0 |
| ACSPUMS1YPR2009 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:58:58.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2009 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2009.0 |
| ACSPUMS1YPR2010 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:02.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2010 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2010.0 |
| ACSPUMS1YPR2011 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:06.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2011 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2011.0 |
| ACSPUMS1YPR2012 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:09.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2012 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2012.0 |
| ACSPUMS1YPR2013 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:14.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2013 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2013.0 |
| ACSPUMS1YPR2014 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:17.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2014 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2014.0 |
| ACSPUMS1YPR2015 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:21.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2015 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2015.0 |
| ACSPUMS1YPR2016 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:25.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2016 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2016.0 |
| ACSPUMS1YPR2017 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:29.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2017 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2017.0 |
| ACSPUMS1YPR2018 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-22 11:59:33.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2018 American Community Survey: 1-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs1, pumspr) | 2018.0 |
| ACSPUMS1YPR2019 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:008 | 2020-06-16 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | ACS 1-Year PUMS Puerto Rico | True | True | NaN | (acs, acs1, pumspr) | 2019.0 |
| ACSPUMS5Y2009 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:05:34.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2005-2009 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2009.0 |
| ACSPUMS5Y2010 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:05:59.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2006-2010 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2010.0 |
| ACSPUMS5Y2011 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:03.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2007-2011 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2011.0 |
| ACSPUMS5Y2012 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:08.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2008-2012 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2012.0 |
| ACSPUMS5Y2013 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:18.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2009-2013 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2013.0 |
| ACSPUMS5Y2014 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:23.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2010-2014 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2014.0 |
| ACSPUMS5Y2015 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:27.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2011-2015 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2015.0 |
| ACSPUMS5Y2016 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:31.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2012-2016 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2016.0 |
| ACSPUMS5Y2017 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:06:35.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2013-2017 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2017.0 |
| ACSPUMS5Y2018 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:008 | 2019-12-19 11:03:12.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2014-2018 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2018.0 |
| ACSPUMS5Y2019 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-11-24 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | ACS 5-Year PUMS | True | True | NaN | (acs, acs5, pums) | 2019.0 |
| ACSPUMS5Y2020 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2022-01-31 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5/pums', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) Public Use Microdata Sample (PUMS) contains a sample of responses to the ACS. The ACS PUMS dataset includes variables for nearly every question on the survey, a... | 006:07 | public | 2020 American Community Survey: 5-Year Estimates - Public Use Microdata Sample | True | True | NaN | (acs, acs5, pums) | 2020.0 |
| ACSPUMS5YPR2009 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:42:53.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2005-2009 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2009.0 |
| ACSPUMS5YPR2010 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:42:59.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2006-2010 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2010.0 |
| ACSPUMS5YPR2011 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:03.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2007-2011 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2011.0 |
| ACSPUMS5YPR2012 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:08.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2008-2012 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2012.0 |
| ACSPUMS5YPR2013 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:12.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2009-2013 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2013.0 |
| ACSPUMS5YPR2014 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:15.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2010-2014 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2014.0 |
| ACSPUMS5YPR2015 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:19.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2011-2015 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2015.0 |
| ACSPUMS5YPR2016 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:23.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2012-2016 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2016.0 |
| ACSPUMS5YPR2017 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-11-25 11:43:27.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2013-2017 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2017.0 |
| ACSPUMS5YPR2018 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:008 | 2019-12-19 11:03:04.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2014-2018 American Community Survey: 5-Year Estimates - Puerto Rico Public Use Microdata Sample | True | True | NaN | (acs, acs5, pumspr) | 2018.0 |
| ACSPUMS5YPR2019 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:008 | 2020-11-24 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | ACS 5-Year PUMS Puerto Rico | True | True | NaN | (acs, acs5, pumspr) | 2019.0 |
| ACSPUMS5YPR2020 | NaN | True | U.S. Census Bureau | NaN | NaN | 006:004 | 2022-01-31 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5/pumspr', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoi... | The Public Use Microdata Sample (PUMS) for Puerto Rico (PR) contains a sample of responses to the Puerto Rico Community Survey (PRCS). The PRCS is similar to, but separate from, the American Commu... | 006:07 | public | 2020 American Community Survey: 5-Year Estimates - Public Use Microdata Sample Puerto Rico | True | True | NaN | (acs, acs5, pumspr) | 2020.0 |
| ACSSE2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acsse', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Supplemental Estimates | True | True | True | (acs, acsse) | 2014.0 |
| ACSSE2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acsse', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Supplemental Estimates | True | True | True | (acs, acsse) | 2015.0 |
| ACSSE2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acsse', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Supplemental Estimates | True | True | True | (acs, acsse) | 2016.0 |
| ACSSE2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-09-07 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acsse', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Supplemental Estimates | True | True | True | (acs, acsse) | 2017.0 |
| ACSSE2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-10 07:41:48.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acsse', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | ACS 1-Year Supplemental Estimates | True | True | True | (acs, acsse) | 2018.0 |
| ACSSE2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acsse', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and therea... | 006:07 | public | American Community Survey: Supplemental Estimates: ACS 1-Year Supplemental Estimates | True | True | True | (acs, acsse) | 2019.0 |
| ACSSF5Y2009 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2017-05-23 | (Income, Marital, Poverty) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | 2005-2009 American Community Survey 5-Year Estimates | True | NaN | True | (acs5,) | 2009.0 |
| ACSSPP1Y2008 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-03-02 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2008/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2008.0 |
| ACSSPP1Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-03-02 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2009.0 |
| ACSSPP1Y2010 | NaN | NaN | U.S. Census Bureau | 2010/2010 | United States | 006:004 | 2020-02-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2010.0 |
| ACSSPP1Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-14 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2011.0 |
| ACSSPP1Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2012.0 |
| ACSSPP1Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-11 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2013.0 |
| ACSSPP1Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-11 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2014.0 |
| ACSSPP1Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-11 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2015.0 |
| ACSSPP1Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-08-07 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2016.0 |
| ACSSPP1Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-09-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2017.0 |
| ACSSPP1Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-07-15 09:36:36.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2018.0 |
| ACSSPP1Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2019.0 |
| ACSSPP1Y2021 | NaN | NaN | U.S. Census Bureau | 2021/2021 | US | 006:004 | 2022-04-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2021/acs/acs1/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | Selected Population Profiles provide broad social, economic, and housing profiles for a large number of race, ethnic, ancestry, and country/region of birth groups. The data are presented as popula... | 006:07 | public | American Community Survey: 1-Year Estimates: Selected Population Profiles 1-Year | True | True | True | (acs, acs1, spp) | 2021.0 |
| ACSSPP3Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-03-02 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs3/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Selected Population Profiles 3-Year | True | True | True | (acs, acs3, spp) | 2009.0 |
| ACSSPP3Y2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-03-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs3/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Selected Population Profiles 3-Year | True | True | True | (acs, acs3, spp) | 2010.0 |
| ACSSPP3Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs3/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Selected Population Profiles 3-Year | True | True | True | (acs, acs3, spp) | 2011.0 |
| ACSSPP3Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs3/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Selected Population Profiles 3-Year | True | True | True | (acs, acs3, spp) | 2012.0 |
| ACSSPP3Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs3/spp', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Selected Population Profiles 3-Year | True | True | True | (acs, acs3, spp) | 2013.0 |
| ACSST1Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2010.0 |
| ACSST1Y2011 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-09-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2011.0 |
| ACSST1Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2012.0 |
| ACSST1Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2013.0 |
| ACSST1Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2014.0 |
| ACSST1Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2015.0 |
| ACSST1Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-20 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2016.0 |
| ACSST1Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-09-06 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2017.0 |
| ACSST1Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-07-15 09:36:47.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 1-Year Subject Tables | True | True | True | (acs, acs1, subject) | 2018.0 |
| ACSST1Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 1-Year Estimates: Subject Tables 1-Year | True | True | True | (acs, acs1, subject) | 2019.0 |
| ACSST1Y2021 | NaN | NaN | U.S. Census Bureau | 2021/2021 | US | 006:004 | 2022-04-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2021/acs/acs1/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is a US-wide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafte... | 006:07 | public | American Community Survey: 1-Year Estimates: Subject Tables 1-Year | True | True | True | (acs, acs1, subject) | 2021.0 |
| ACSST3Y2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-05 15:59:41.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs3/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Subject Tables 3-Year | True | True | True | (acs, acs3, subject) | 2010.0 |
| ACSST3Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-10 10:38:37.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs3/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Subject Tables 3-Year | True | True | True | (acs, acs3, subject) | 2011.0 |
| ACSST3Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-12 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs3/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Subject Tables 3-Year | True | True | True | (acs, acs3, subject) | 2012.0 |
| ACSST3Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-10 15:55:41.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs3/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 3-Year Estimates: Subject Tables 3-Year | True | True | True | (acs, acs3, subject) | 2013.0 |
| ACSST5Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-09-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2010.0 |
| ACSST5Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2011.0 |
| ACSST5Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2012.0 |
| ACSST5Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2013.0 |
| ACSST5Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2014.0 |
| ACSST5Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2015.0 |
| ACSST5Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-06-29 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2016.0 |
| ACSST5Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-10-19 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2017.0 |
| ACSST5Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-22 15:36:29.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Subject Tables | True | True | True | (acs, acs5, subject) | 2018.0 |
| ACSST5Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Subject Tables 5-Year | True | True | True | (acs, acs5, subject) | 2019.0 |
| ACSST5Y2020 | NaN | NaN | U.S. Census Bureau | 2020/2020 | US | 006:004 | 2021-07-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5/subject', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpo... | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Subject Tables 5-Year | True | True | True | (acs, acs5, subject) | 2020.0 |
Many flavors of ACS datasets are available — we want to use the detailed tables version, specifically the 5-year survey.
The relevant identifiers start with: "ACSDT5Y".
# Return a dataframe of all datasets that start with "ACSDT5Y"
available.filter(regex="^ACSDT5Y", axis=0)
| c_isTimeseries | c_isMicrodata | publisher | temporal | spatial | programCode | modified | keyword | contactPoint | distribution | description | bureauCode | accessLevel | title | c_isAvailable | c_isCube | c_isAggregate | c_dataset | vintage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACSDT5Y2009 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-08-27 13:11:18.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2009/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2009.0 |
| ACSDT5Y2010 | NaN | NaN | U.S. Census Bureau | NaN | United States | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2010.0 |
| ACSDT5Y2011 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2011/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2011.0 |
| ACSDT5Y2012 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2012/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2012.0 |
| ACSDT5Y2013 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2013/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2013.0 |
| ACSDT5Y2014 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-04 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2014/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2014.0 |
| ACSDT5Y2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2015.0 |
| ACSDT5Y2016 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-07-05 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2016/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2016.0 |
| ACSDT5Y2017 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2018-08-21 07:11:43.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2017/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | ACS 5-Year Detailed Tables | True | True | True | (acs, acs5) | 2017.0 |
| ACSDT5Y2018 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-22 16:28:02.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2018/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2018.0 |
| ACSDT5Y2019 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-04-03 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:Acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2019/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2019.0 |
| ACSDT5Y2020 | NaN | NaN | U.S. Census Bureau | 2020/2020 | US | 006:004 | 2021-07-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2020/acs/acs5', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a br... | 006:07 | public | American Community Survey: 5-Year Estimates: Detailed Tables 5-Year | True | True | True | (acs, acs5) | 2020.0 |
| ACSDT5YAIAN2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-24 07:18:57.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/aian', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Indian and Alaska Native (AIAN) tables are released every five years. They are available for selected tribal populations, with more detailed tribal categories compared to those in the... | 006:07 | public | American Community Survey: 5-Year Estimates: American Indian and Alaska Native Detailed Tables 5-Year | True | True | True | (acs, acs5, aian) | 2010.0 |
| ACSDT5YAIAN2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-13 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/aian', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The American Indian and Alaska Native (AIAN) tables are released every five years. They are available for selected tribal populations, with more detailed tribal categories compared to those in the... | 006:07 | public | ACS 5-Year AIAN Detailed Tables | True | True | True | (acs, acs5, aian) | 2015.0 |
| ACSDT5YSPT2010 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2019-10-11 14:16:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2010/acs/acs5/spt', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Selected Population Tables (SPT) are released every five years. They are available for selected race, Hispanic origin, tribal, and ancestry populations. | 006:07 | public | American Community Survey: 5-Year Estimates: Selected Population Detailed Tables 5-Year | True | True | True | (acs, acs5, spt) | 2010.0 |
| ACSDT5YSPT2015 | NaN | NaN | U.S. Census Bureau | NaN | NaN | 006:004 | 2020-02-18 00:00:00.0 | (census,) | {'fn': 'American Community Survey Office', 'hasEmail': 'mailto:acso.users.support@census.gov'} | {'@type': 'dcat:Distribution', 'accessURL': 'http://api.census.gov/data/2015/acs/acs5/spt', 'description': 'API endpoint', 'format': 'API', 'mediaType': 'application/json', 'title': 'API endpoint'} | The Selected Population Tables (SPT) are released every five years. They are available for selected race, Hispanic origin, tribal, and ancestry populations. | 006:07 | public | American Community Survey: 5-Year Estimates: Selected Population Detailed Tables 5-Year | True | True | True | (acs, acs5, spt) | 2015.0 |
Let's use the latest available 5-year data (2020). We can use the explain() function to print out a description of the dataset:
cenpy.explorer.explain("ACSDT5Y2020")
{'American Community Survey: 5-Year Estimates: Detailed Tables 5-Year': 'The American Community Survey (ACS) is an ongoing survey that provides data every year -- giving communities the current information they need to plan investments and services. The ACS covers a broad range of topics about social, economic, demographic, and housing characteristics of the U.S. population. Summary files include the following geographies: nation, all states (including DC and Puerto Rico), all metropolitan areas, all congressional districts (117th Congress), all counties, all places, and all tracts and block groups. Summary files contain the most detailed cross-tabulations, many of which are published down to block groups. The data are population and housing counts. There are over 64,000 variables in this dataset.'}
Use the cenpy.remote.APIConnection object, and pass it the name of the dataset.
acs = cenpy.remote.APIConnection("ACSDT5Y2020")
The .variables attribute stores the available variables (across all Census tables).
We can use the varslike() function to search the variables dataframe (it's just a simple wrapper around the pandas filter() function).
len(acs.variables)
27892
acs.variables.head(n=10)
| label | concept | predicateType | group | limit | predicateOnly | hasGeoCollectionSupport | attributes | required | |
|---|---|---|---|---|---|---|---|---|---|
| for | Census API FIPS 'for' clause | Census API Geography Specification | fips-for | N/A | 0 | True | NaN | NaN | NaN |
| in | Census API FIPS 'in' clause | Census API Geography Specification | fips-in | N/A | 0 | True | NaN | NaN | NaN |
| ucgid | Uniform Census Geography Identifier clause | Census API Geography Specification | ucgid | N/A | 0 | True | True | NaN | NaN |
| B24022_060E | Estimate!!Total:!!Female:!!Service occupations:!!Food preparation and serving related occupations | SEX BY OCCUPATION AND MEDIAN EARNINGS IN THE PAST 12 MONTHS (IN 2020 INFLATION-ADJUSTED DOLLARS) FOR THE FULL-TIME, YEAR-ROUND CIVILIAN EMPLOYED POPULATION 16 YEARS AND OVER | int | B24022 | 0 | NaN | NaN | B24022_060EA,B24022_060M,B24022_060MA | NaN |
| B19001B_014E | Estimate!!Total:!!$100,000 to $124,999 | HOUSEHOLD INCOME IN THE PAST 12 MONTHS (IN 2020 INFLATION-ADJUSTED DOLLARS) (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) | int | B19001B | 0 | NaN | NaN | B19001B_014EA,B19001B_014M,B19001B_014MA | NaN |
| B07007PR_019E | Estimate!!Total:!!Moved from different municipio:!!Foreign born:!!Naturalized U.S. citizen | GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY CITIZENSHIP STATUS FOR CURRENT RESIDENCE IN PUERTO RICO | int | B07007PR | 0 | NaN | NaN | B07007PR_019EA,B07007PR_019M,B07007PR_019MA | NaN |
| B19101A_004E | Estimate!!Total:!!$15,000 to $19,999 | FAMILY INCOME IN THE PAST 12 MONTHS (IN 2020 INFLATION-ADJUSTED DOLLARS) (WHITE ALONE HOUSEHOLDER) | int | B19101A | 0 | NaN | NaN | B19101A_004EA,B19101A_004M,B19101A_004MA | NaN |
| B24022_061E | Estimate!!Total:!!Female:!!Service occupations:!!Building and grounds cleaning and maintenance occupations | SEX BY OCCUPATION AND MEDIAN EARNINGS IN THE PAST 12 MONTHS (IN 2020 INFLATION-ADJUSTED DOLLARS) FOR THE FULL-TIME, YEAR-ROUND CIVILIAN EMPLOYED POPULATION 16 YEARS AND OVER | int | B24022 | 0 | NaN | NaN | B24022_061EA,B24022_061M,B24022_061MA | NaN |
| B19001B_013E | Estimate!!Total:!!$75,000 to $99,999 | HOUSEHOLD INCOME IN THE PAST 12 MONTHS (IN 2020 INFLATION-ADJUSTED DOLLARS) (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) | int | B19001B | 0 | NaN | NaN | B19001B_013EA,B19001B_013M,B19001B_013MA | NaN |
| B07007PR_018E | Estimate!!Total:!!Moved from different municipio:!!Foreign born: | GEOGRAPHICAL MOBILITY IN THE PAST YEAR BY CITIZENSHIP STATUS FOR CURRENT RESIDENCE IN PUERTO RICO | int | B07007PR | 0 | NaN | NaN | B07007PR_018EA,B07007PR_018M,B07007PR_018MA | NaN |
We're interested in variables about hispanic origin broken down by race — let's see if we can find the variables where the "Concept" column starts with "RACE"
acs.varslike?
Signature: acs.varslike(pattern=None, by=None, engine='re', within=None) Docstring: Grabs columns that match a particular search pattern. Parameters ---------- pattern : str a search pattern to match by : str a column in the APIConnection.variables to conduct the search within engine : {'re', 'fnmatch', callable} backend string matching module to use, or a function of the form match(candidate, pattern). (default: 're') within : pandas.DataFrame the variables over which to search. Notes ------ Only regex and fnmatch will be supported modules. Note that, while regex is the default, the python regular expressions module has some strange behavior if you're used to VIM or Perl-like regex. It may be easier to use fnmatch if regex is not providing the results you expect. If you want, you can also pass an engine that is a function. If so, this needs to be a function that has a signature like: fn(candidate, pattern) and return True or False if the candidate matches the pattern. So, for instance, you can use any string processing function: >>> cxn.varslike('_100M', engine = lambda c,p: c.endswith(p) which may also be expressed as a regexp: >>> cxn.varslike('_100M$', engine='re') or an fnmatch pattern: >>> cxn.varslike('*_100M', engine='fnmatch') File: ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/cenpy/remote.py Type: method
acs.varslike("HISPANIC OR LATINO ORIGIN BY RACE", by='concept').sort_index() # searches along concept column
| label | concept | predicateType | group | limit | predicateOnly | hasGeoCollectionSupport | attributes | required | |
|---|---|---|---|---|---|---|---|---|---|
| B03002_001E | Estimate!!Total: | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_001EA,B03002_001M,B03002_001MA | NaN |
| B03002_002E | Estimate!!Total:!!Not Hispanic or Latino: | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_002EA,B03002_002M,B03002_002MA | NaN |
| B03002_003E | Estimate!!Total:!!Not Hispanic or Latino:!!White alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_003EA,B03002_003M,B03002_003MA | NaN |
| B03002_004E | Estimate!!Total:!!Not Hispanic or Latino:!!Black or African American alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_004EA,B03002_004M,B03002_004MA | NaN |
| B03002_005E | Estimate!!Total:!!Not Hispanic or Latino:!!American Indian and Alaska Native alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_005EA,B03002_005M,B03002_005MA | NaN |
| B03002_006E | Estimate!!Total:!!Not Hispanic or Latino:!!Asian alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_006EA,B03002_006M,B03002_006MA | NaN |
| B03002_007E | Estimate!!Total:!!Not Hispanic or Latino:!!Native Hawaiian and Other Pacific Islander alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_007EA,B03002_007M,B03002_007MA | NaN |
| B03002_008E | Estimate!!Total:!!Not Hispanic or Latino:!!Some other race alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_008EA,B03002_008M,B03002_008MA | NaN |
| B03002_009E | Estimate!!Total:!!Not Hispanic or Latino:!!Two or more races: | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_009EA,B03002_009M,B03002_009MA | NaN |
| B03002_010E | Estimate!!Total:!!Not Hispanic or Latino:!!Two or more races:!!Two races including Some other race | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_010EA,B03002_010M,B03002_010MA | NaN |
| B03002_011E | Estimate!!Total:!!Not Hispanic or Latino:!!Two or more races:!!Two races excluding Some other race, and three or more races | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_011EA,B03002_011M,B03002_011MA | NaN |
| B03002_012E | Estimate!!Total:!!Hispanic or Latino: | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_012EA,B03002_012M,B03002_012MA | NaN |
| B03002_013E | Estimate!!Total:!!Hispanic or Latino:!!White alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_013EA,B03002_013M,B03002_013MA | NaN |
| B03002_014E | Estimate!!Total:!!Hispanic or Latino:!!Black or African American alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_014EA,B03002_014M,B03002_014MA | NaN |
| B03002_015E | Estimate!!Total:!!Hispanic or Latino:!!American Indian and Alaska Native alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_015EA,B03002_015M,B03002_015MA | NaN |
| B03002_016E | Estimate!!Total:!!Hispanic or Latino:!!Asian alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_016EA,B03002_016M,B03002_016MA | NaN |
| B03002_017E | Estimate!!Total:!!Hispanic or Latino:!!Native Hawaiian and Other Pacific Islander alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_017EA,B03002_017M,B03002_017MA | NaN |
| B03002_018E | Estimate!!Total:!!Hispanic or Latino:!!Some other race alone | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_018EA,B03002_018M,B03002_018MA | NaN |
| B03002_019E | Estimate!!Total:!!Hispanic or Latino:!!Two or more races: | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_019EA,B03002_019M,B03002_019MA | NaN |
| B03002_020E | Estimate!!Total:!!Hispanic or Latino:!!Two or more races:!!Two races including Some other race | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_020EA,B03002_020M,B03002_020MA | NaN |
| B03002_021E | Estimate!!Total:!!Hispanic or Latino:!!Two or more races:!!Two races excluding Some other race, and three or more races | HISPANIC OR LATINO ORIGIN BY RACE | int | B03002 | 0 | NaN | NaN | B03002_021EA,B03002_021M,B03002_021MA | NaN |
| GEO_ID | Geography | SEX BY EDUCATIONAL ATTAINMENT FOR THE POPULATION 25 YEARS AND OVER (SOME OTHER RACE ALONE);SEX BY EDUCATIONAL ATTAINMENT FOR THE POPULATION 25 YEARS AND OVER (TWO OR MORE RACES);SEX BY EDUCATIONAL... | string | B17015,B18104,B17016,B18105,B17017,B18106,B17018,B18107,B19301A,B07001PR,B17011,B17012,B18101,B17013,B18102,B17014,B18103,B19301E,B19301D,B19301C,B19301B,B17010,B19301I,B98013,B99102,B19301H,B9801... | 0 | NaN | NaN | NAME | NaN |
It looks like the table we want is "B03002" — we can also easily filter for all variables in this table
variables = [
"NAME",
"B03002_001E", # Total
"B03002_003E", # Not Hispanic, White
"B03002_004E", # Not Hispanic, Black
"B03002_005E", # Not Hispanic, American Indian
"B03002_006E", # Not Hispanic, Asian
"B03002_007E", # Not Hispanic, Native Hawaiian
"B03002_008E", # Not Hispanic, Other
"B03002_009E", # Not Hispanic, Two or More Races
"B03002_012E", # Hispanic
]
Note: we've also include the "NAME" variable which returns the name of the Census geography we are querying for
The Census API use heirarchy of geographies when requesting data.
For example, you cannot just request data for a specific county — you need to specify the state and the county.
Common hierarchies
Tip: Use the .geographies attribute
This allows you to see:
acs.geographies['fips']
| name | geoLevelDisplay | referenceDate | requires | wildcard | optionalWithWCFor | |
|---|---|---|---|---|---|---|
| 0 | us | 010 | 2020-01-01 | NaN | NaN | NaN |
| 1 | region | 020 | 2020-01-01 | NaN | NaN | NaN |
| 2 | division | 030 | 2020-01-01 | NaN | NaN | NaN |
| 3 | state | 040 | 2020-01-01 | NaN | NaN | NaN |
| 4 | county | 050 | 2020-01-01 | [state] | [state] | state |
| 5 | county subdivision | 060 | 2020-01-01 | [state, county] | [county] | county |
| 6 | subminor civil division | 067 | 2020-01-01 | [state, county, county subdivision] | NaN | NaN |
| 7 | place/remainder (or part) | 070 | 2020-01-01 | [state, county, county subdivision] | NaN | NaN |
| 8 | tract | 140 | 2020-01-01 | [state, county] | [county] | county |
| 9 | block group | 150 | 2020-01-01 | [state, county, tract] | [county, tract] | tract |
| 10 | county (or part) | 155 | 2020-01-01 | [state, place] | NaN | NaN |
| 11 | place | 160 | 2020-01-01 | [state] | [state] | state |
| 12 | consolidated city | 170 | 2020-01-01 | [state] | NaN | NaN |
| 13 | place (or part) | 172 | 2020-01-01 | [state, consolidated city] | NaN | NaN |
| 14 | alaska native regional corporation | 230 | 2020-01-01 | [state] | [state] | state |
| 15 | american indian area/alaska native area/hawaiian home land | 250 | 2020-01-01 | NaN | NaN | NaN |
| 16 | tribal subdivision/remainder | 251 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land] | NaN | NaN |
| 17 | american indian area/alaska native area (reservation or statistical entity only) | 252 | 2020-01-01 | NaN | NaN | NaN |
| 18 | american indian area (off-reservation trust land only)/hawaiian home land | 254 | 2020-01-01 | NaN | NaN | NaN |
| 19 | tribal census tract | 256 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land] | NaN | NaN |
| 20 | tribal block group | 258 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land, tribal census tract] | NaN | NaN |
| 21 | state (or part) | 260 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land] | NaN | NaN |
| 22 | place/remainder (or part) | 269 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land, state (or part)] | NaN | NaN |
| 23 | county (or part) | 270 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land, state (or part)] | NaN | NaN |
| 24 | american indian area/alaska native area/hawaiian home land (or part) | 280 | 2020-01-01 | [state] | NaN | NaN |
| 25 | american indian area/alaska native area (reservation or statistical entity only) (or part) | 283 | 2020-01-01 | [state] | NaN | NaN |
| 26 | american indian area (off-reservation trust land only)/hawaiian home land (or part) | 286 | 2020-01-01 | [state] | NaN | NaN |
| 27 | state (or part) | 290 | 2020-01-01 | [american indian area/alaska native area/hawaiian home land, tribal subdivision/remainder] | NaN | NaN |
| 28 | tribal census tract (or part) | 291 | 2020-01-01 | [american indian area (reservation only)] | NaN | NaN |
| 29 | tribal census tract (or part) | 292 | 2020-01-01 | [american indian area (off-reservation trust land only)/hawaiian home land] | NaN | NaN |
| 30 | tribal block group (or part) | 293 | 2020-01-01 | [american indian area (reservation only), tribal census tract (or part)] | NaN | NaN |
| 31 | tribal block group (or part) | 294 | 2020-01-01 | [american indian area (off-reservation trust land only)/hawaiian home land, tribal census tract (or part)] | NaN | NaN |
| 32 | metropolitan statistical area/micropolitan statistical area | 310 | 2020-01-01 | NaN | NaN | NaN |
| 33 | state (or part) | 311 | 2020-01-01 | [metropolitan statistical area/micropolitan statistical area] | NaN | NaN |
| 34 | principal city (or part) | 312 | 2020-01-01 | [metropolitan statistical area/micropolitan statistical area, state (or part)] | NaN | NaN |
| 35 | county | 313 | 2020-01-01 | [metropolitan statistical area/micropolitan statistical area, state (or part)] | NaN | NaN |
| 36 | metropolitan division | 314 | 2020-01-01 | [metropolitan statistical area/micropolitan statistical area] | NaN | NaN |
| 37 | state (or part) | 315 | 2020-01-01 | [metropolitan statistical area/micropolitan statistical area, metropolitan division] | NaN | NaN |
| 38 | county | 316 | 2020-01-01 | [metropolitan statistical area/micropolitan statistical area, metropolitan division, state (or part)] | NaN | NaN |
| 39 | metropolitan statistical area/micropolitan statistical area (or part) | 320 | 2020-01-01 | [state] | NaN | NaN |
| 40 | principal city (or part) | 321 | 2020-01-01 | [state, metropolitan statistical area/micropolitan statistical area (or part)] | NaN | NaN |
| 41 | county | 322 | 2020-01-01 | [state, metropolitan statistical area/micropolitan statistical area (or part)] | NaN | NaN |
| 42 | metropolitan division (or part) | 323 | 2020-01-01 | [state, metropolitan statistical area/micropolitan statistical area (or part)] | NaN | NaN |
| 43 | county | 324 | 2020-01-01 | [state, metropolitan statistical area/micropolitan statistical area (or part), metropolitan division (or part)] | NaN | NaN |
| 44 | combined statistical area | 330 | 2020-01-01 | NaN | NaN | NaN |
| 45 | state (or part) | 331 | 2020-01-01 | [combined statistical area] | NaN | NaN |
| 46 | metropolitan statistical area/micropolitan statistical area | 332 | 2020-01-01 | [combined statistical area] | NaN | NaN |
| 47 | state (or part) | 333 | 2020-01-01 | [combined statistical area, metropolitan statistical area/micropolitan statistical area] | NaN | NaN |
| 48 | combined new england city and town area | 335 | 2020-01-01 | NaN | NaN | NaN |
| 49 | state (or part) | 336 | 2020-01-01 | [combined new england city and town area] | [combined new england city and town area] | combined new england city and town area |
| 50 | new england city and town area | 337 | 2020-01-01 | [combined new england city and town area] | NaN | NaN |
| 51 | state (or part) | 338 | 2020-01-01 | [combined new england city and town area, new england city and town area] | NaN | NaN |
| 52 | combined statistical area (or part) | 340 | 2020-01-01 | [state] | NaN | NaN |
| 53 | metropolitan statistical area/micropolitan statistical area (or part) | 341 | 2020-01-01 | [state, combined statistical area (or part)] | NaN | NaN |
| 54 | combined new england city and town area (or part) | 345 | 2020-01-01 | [state] | NaN | NaN |
| 55 | new england city and town area (or part) | 346 | 2020-01-01 | [state, combined new england city and town area (or part)] | NaN | NaN |
| 56 | new england city and town area | 350 | 2020-01-01 | NaN | NaN | NaN |
| 57 | state (or part) | 351 | 2020-01-01 | [new england city and town area] | NaN | NaN |
| 58 | principal city | 352 | 2020-01-01 | [new england city and town area, state (or part)] | NaN | NaN |
| 59 | county (or part) | 353 | 2020-01-01 | [new england city and town area, state (or part)] | NaN | NaN |
| 60 | county subdivision | 354 | 2020-01-01 | [new england city and town area, state (or part), county (or part)] | NaN | NaN |
| 61 | necta division | 355 | 2020-01-01 | [new england city and town area] | NaN | NaN |
| 62 | state (or part) | 356 | 2020-01-01 | [new england city and town area, necta division] | NaN | NaN |
| 63 | county (or part) | 357 | 2020-01-01 | [new england city and town area, necta division, state (or part)] | NaN | NaN |
| 64 | county subdivision | 358 | 2020-01-01 | [new england city and town area, necta division, state (or part), county (or part)] | NaN | NaN |
| 65 | new england city and town area (or part) | 360 | 2020-01-01 | [state] | NaN | NaN |
| 66 | principal city | 361 | 2020-01-01 | [state, new england city and town area (or part)] | NaN | NaN |
| 67 | county (or part) | 362 | 2020-01-01 | [state, new england city and town area (or part)] | NaN | NaN |
| 68 | county subdivision | 363 | 2020-01-01 | [state, new england city and town area (or part), county (or part)] | NaN | NaN |
| 69 | necta division (or part) | 364 | 2020-01-01 | [state, new england city and town area (or part)] | NaN | NaN |
| 70 | county (or part) | 365 | 2020-01-01 | [state, new england city and town area (or part), necta division (or part)] | NaN | NaN |
| 71 | county subdivision | 366 | 2020-01-01 | [state, new england city and town area (or part), necta division (or part), county (or part)] | NaN | NaN |
| 72 | urban area | 400 | 2020-01-01 | NaN | NaN | NaN |
| 73 | state | 410 | 2020-01-01 | [urban area] | NaN | NaN |
| 74 | county | 430 | 2020-01-01 | [urban area, state] | NaN | NaN |
| 75 | congressional district | 500 | 2020-01-01 | [state] | [state] | state |
| 76 | county (or part) | 510 | 2020-01-01 | [state, congressional district] | NaN | NaN |
| 77 | american indian area/alaska native area/hawaiian home land (or part) | 550 | 2020-01-01 | [state, congressional district] | NaN | NaN |
| 78 | state legislative district (upper chamber) | 610 | 2020-01-01 | [state] | NaN | NaN |
| 79 | county (or part) | 612 | 2020-01-01 | [state, state legislative district (upper chamber)] | NaN | NaN |
| 80 | state legislative district (lower chamber) | 620 | 2020-01-01 | [state] | NaN | NaN |
| 81 | county (or part) | 622 | 2020-01-01 | [state, state legislative district (lower chamber)] | NaN | NaN |
| 82 | public use microdata area | 795 | 2020-01-01 | [state] | [state] | state |
| 83 | zip code tabulation area | 860 | 2020-01-01 | NaN | NaN | NaN |
| 84 | school district (elementary) | 950 | 2020-01-01 | [state] | [state] | state |
| 85 | school district (secondary) | 960 | 2020-01-01 | [state] | [state] | state |
| 86 | school district (unified) | 970 | 2020-01-01 | [state] | [state] | state |
For the racial dot map, we'll use the most granular available geography: block group.
The hierarchy is: state --> county --> tract --> block group but we can use the * operator for tracts so we'll need to know the FIPS codes for PA and Philadelphia County
counties = cenpy.explorer.fips_table("COUNTY")
counties.head()
| 0 | 1 | 2 | 3 | 4 | |
|---|---|---|---|---|---|
| 0 | AL | 1 | 1 | Autauga County | H1 |
| 1 | AL | 1 | 3 | Baldwin County | H1 |
| 2 | AL | 1 | 5 | Barbour County | H1 |
| 3 | AL | 1 | 7 | Bibb County | H1 |
| 4 | AL | 1 | 9 | Blount County | H1 |
# Trim to just Philadelphia
# Search for rows where name contains "Philadelphia"
counties.loc[ counties[3].str.contains("Philadelphia") ]
| 0 | 1 | 2 | 3 | 4 | |
|---|---|---|---|---|---|
| 2294 | PA | 42 | 101 | Philadelphia County | H6 |
For Philadelphia County, the FIPS codes are:
philly_county_code = "101"
pa_state_code = "42"
You can also look up FIPS codes on Google! Wikipedia is usually a trustworthy source...
We'll use the .query() function, which takes the following arguments:
cols - the list of variables desired from the datasetgeo_unit - string denoting the smallest geographic unit; syntax is "name:FIPS"geo_filter - dictionary containing groupings of geo_units, if required by the hierarchyphilly_demo_data = acs.query(
cols=variables,
geo_unit="block group:*",
geo_filter={"state": pa_state_code,
"county": philly_county_code,
"tract": "*"},
)
philly_demo_data.head()
| NAME | B03002_001E | B03002_003E | B03002_004E | B03002_005E | B03002_006E | B03002_007E | B03002_008E | B03002_009E | B03002_012E | state | county | tract | block group | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Block Group 3, Census Tract 1.01, Philadelphia County, Pennsylvania | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 101 | 000101 | 3 |
| 1 | Block Group 1, Census Tract 1.02, Philadelphia County, Pennsylvania | 1499 | 1318 | 30 | 0 | 40 | 0 | 0 | 33 | 78 | 42 | 101 | 000102 | 1 |
| 2 | Block Group 4, Census Tract 1.02, Philadelphia County, Pennsylvania | 316 | 316 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 101 | 000102 | 4 |
| 3 | Block Group 2, Census Tract 2, Philadelphia County, Pennsylvania | 1090 | 490 | 40 | 0 | 548 | 0 | 0 | 12 | 0 | 42 | 101 | 000200 | 2 |
| 4 | Block Group 2, Census Tract 5, Philadelphia County, Pennsylvania | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 101 | 000500 | 2 |
Important: data is returned as strings rather than numeric values
for variable in variables:
# Convert all variables EXCEPT for NAME
if variable != "NAME":
philly_demo_data[variable] = philly_demo_data[variable].astype(float)
What if we mess up the geographic hierarchy?
If you forget to include required parts of the geography heirarchy, you'll get an error!
acs.query(
cols=variables,
geo_unit="block group:*",
geo_filter={"state": pa_state_code},
)
/Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/cenpy/remote.py:224: SyntaxWarning: "is not" with a literal. Did you mean "!="? if index is not "": /Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/cenpy/remote.py:224: SyntaxWarning: "is not" with a literal. Did you mean "!="? if index is not "":
--------------------------------------------------------------------------- JSONDecodeError Traceback (most recent call last) File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/requests/models.py:971, in Response.json(self, **kwargs) 970 try: --> 971 return complexjson.loads(self.text, **kwargs) 972 except JSONDecodeError as e: 973 # Catch JSON-related errors and raise as requests.JSONDecodeError 974 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/simplejson/__init__.py:525, in loads(s, encoding, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, use_decimal, **kw) 521 if (cls is None and encoding is None and object_hook is None and 522 parse_int is None and parse_float is None and 523 parse_constant is None and object_pairs_hook is None 524 and not use_decimal and not kw): --> 525 return _default_decoder.decode(s) 526 if cls is None: File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/simplejson/decoder.py:370, in JSONDecoder.decode(self, s, _w, _PY3) 369 s = str(s, self.encoding) --> 370 obj, end = self.raw_decode(s) 371 end = _w(s, end).end() File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/simplejson/decoder.py:400, in JSONDecoder.raw_decode(self, s, idx, _w, _PY3) 399 idx += 3 --> 400 return self.scan_once(s, idx=_w(s, idx).end()) JSONDecodeError: Expecting value: line 1 column 1 (char 0) During handling of the above exception, another exception occurred: JSONDecodeError Traceback (most recent call last) File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/cenpy/remote.py:219, in APIConnection.query(self, cols, geo_unit, geo_filter, apikey, **kwargs) 218 try: --> 219 json_content = res.json() 220 df = pd.DataFrame().from_records(json_content[1:], columns=json_content[0]) File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/requests/models.py:975, in Response.json(self, **kwargs) 972 except JSONDecodeError as e: 973 # Catch JSON-related errors and raise as requests.JSONDecodeError 974 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError --> 975 raise RequestsJSONDecodeError(e.msg, e.doc, e.pos) JSONDecodeError: Expecting value: line 1 column 1 (char 0) During handling of the above exception, another exception occurred: HTTPError Traceback (most recent call last) Input In [75], in <cell line: 1>() ----> 1 acs.query( 2 cols=variables, 3 geo_unit="block group:*", 4 geo_filter={"state": pa_state_code}, 5 ) File ~/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/cenpy/remote.py:229, in APIConnection.query(self, cols, geo_unit, geo_filter, apikey, **kwargs) 227 except (ValueError, JSONDecodeError): 228 if res.status_code == 400: --> 229 raise r.HTTPError( 230 "400 " + "\n".join(map(lambda x: x.decode(), res.iter_lines())) 231 ) 232 else: 233 res.raise_for_status() HTTPError: 400 error: unknown/unsupported geography heirarchy
cenpy includes an interface to the Census' [Tiger] shapefile database.
cenpy.tiger.available()
[{'name': 'AIANNHA', 'type': 'MapServer'},
{'name': 'CBSA', 'type': 'MapServer'},
{'name': 'Hydro', 'type': 'MapServer'},
{'name': 'Labels', 'type': 'MapServer'},
{'name': 'Legislative', 'type': 'MapServer'},
{'name': 'Places_CouSub_ConCity_SubMCD', 'type': 'MapServer'},
{'name': 'PUMA_TAD_TAZ_UGA_ZCTA', 'type': 'MapServer'},
{'name': 'Region_Division', 'type': 'MapServer'},
{'name': 'School', 'type': 'MapServer'},
{'name': 'Special_Land_Use_Areas', 'type': 'MapServer'},
{'name': 'State_County', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2012', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2013', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2014', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2015', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2016', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2017', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2018', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2019', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2021', 'type': 'MapServer'},
{'name': 'tigerWMS_ACS2022', 'type': 'MapServer'},
{'name': 'tigerWMS_Census2010', 'type': 'MapServer'},
{'name': 'tigerWMS_Census2020', 'type': 'MapServer'},
{'name': 'tigerWMS_Current', 'type': 'MapServer'},
{'name': 'tigerWMS_ECON2012', 'type': 'MapServer'},
{'name': 'tigerWMS_PhysicalFeatures', 'type': 'MapServer'},
{'name': 'Tracts_Blocks', 'type': 'MapServer'},
{'name': 'Transportation', 'type': 'MapServer'},
{'name': 'TribalTracts', 'type': 'MapServer'},
{'name': 'Urban', 'type': 'MapServer'},
{'name': 'USLandmass', 'type': 'MapServer'}]
Set the tigerWMS_Census2020 database as the desired GeoService.
acs.set_mapservice("tigerWMS_Census2020")
Connection to American Community Survey: 5-Year Estimates: Detailed Tables 5-Year(ID: https://api.census.gov/data/id/ACSDT5Y2020) With MapServer: Census 2020 WMS
The map service has many different layers — select the layer for our desired geography
acs.mapservice.layers
[(ESRILayer) Urban Growth Areas, (ESRILayer) Urban Growth Areas Labels, (ESRILayer) Tribal Census Tracts, (ESRILayer) Tribal Census Tracts Labels, (ESRILayer) Tribal Block Groups, (ESRILayer) Tribal Block Groups Labels, (ESRILayer) Census Tracts, (ESRILayer) Census Tracts Labels, (ESRILayer) Census Block Groups, (ESRILayer) Census Block Groups Labels, (ESRILayer) Census Blocks, (ESRILayer) Census Blocks Labels, (ESRILayer) Unified School Districts, (ESRILayer) Unified School Districts Labels, (ESRILayer) Secondary School Districts, (ESRILayer) Secondary School Districts Labels, (ESRILayer) Elementary School Districts, (ESRILayer) Elementary School Districts Labels, (ESRILayer) Estates, (ESRILayer) Estates Labels, (ESRILayer) County Subdivisions, (ESRILayer) County Subdivisions Labels, (ESRILayer) Subbarrios, (ESRILayer) Subbarrios Labels, (ESRILayer) Consolidated Cities, (ESRILayer) Consolidated Cities Labels, (ESRILayer) Incorporated Places, (ESRILayer) Incorporated Places Labels, (ESRILayer) Census Designated Places, (ESRILayer) Census Designated Places Labels, (ESRILayer) Alaska Native Regional Corporations, (ESRILayer) Alaska Native Regional Corporations Labels, (ESRILayer) Tribal Subdivisions, (ESRILayer) Tribal Subdivisions Labels, (ESRILayer) Federal American Indian Reservations, (ESRILayer) Federal American Indian Reservations Labels, (ESRILayer) Off-Reservation Trust Lands, (ESRILayer) Off-Reservation Trust Lands Labels, (ESRILayer) State American Indian Reservations, (ESRILayer) State American Indian Reservations Labels, (ESRILayer) Hawaiian Home Lands, (ESRILayer) Hawaiian Home Lands Labels, (ESRILayer) Alaska Native Village Statistical Areas, (ESRILayer) Alaska Native Village Statistical Areas Labels, (ESRILayer) Oklahoma Tribal Statistical Areas, (ESRILayer) Oklahoma Tribal Statistical Areas Labels, (ESRILayer) State Designated Tribal Statistical Areas, (ESRILayer) State Designated Tribal Statistical Areas Labels, (ESRILayer) Tribal Designated Statistical Areas, (ESRILayer) Tribal Designated Statistical Areas Labels, (ESRILayer) American Indian Joint-Use Areas, (ESRILayer) American Indian Joint-Use Areas Labels, (ESRILayer) 116th Congressional Districts, (ESRILayer) 116th Congressional Districts Labels, (ESRILayer) 2018 State Legislative Districts - Upper, (ESRILayer) 2018 State Legislative Districts - Upper Labels, (ESRILayer) 2018 State Legislative Districts - Lower, (ESRILayer) 2018 State Legislative Districts - Lower Labels, (ESRILayer) Voting Districts, (ESRILayer) Voting Districts Labels, (ESRILayer) Census Divisions, (ESRILayer) Census Divisions Labels, (ESRILayer) Census Regions, (ESRILayer) Census Regions Labels, (ESRILayer) Combined New England City and Town Areas, (ESRILayer) Combined New England City and Town Areas Labels, (ESRILayer) New England City and Town Area Divisions, (ESRILayer) New England City and Town Area Divisions Labels, (ESRILayer) Metropolitan New England City and Town Areas, (ESRILayer) Metropolitan New England City and Town Areas Labels, (ESRILayer) Micropolitan New England City and Town Areas, (ESRILayer) Micropolitan New England City and Town Areas Labels, (ESRILayer) Combined Statistical Areas, (ESRILayer) Combined Statistical Areas Labels, (ESRILayer) Metropolitan Divisions, (ESRILayer) Metropolitan Divisions Labels, (ESRILayer) Metropolitan Statistical Areas, (ESRILayer) Metropolitan Statistical Areas Labels, (ESRILayer) Micropolitan Statistical Areas, (ESRILayer) Micropolitan Statistical Areas Labels, (ESRILayer) States, (ESRILayer) States Labels, (ESRILayer) Counties, (ESRILayer) Counties Labels, (ESRILayer) Zip Code Tabulation Areas, (ESRILayer) Zip Code Tabulation Areas Labels, (ESRILayer) Public Use Microdata Areas, (ESRILayer) Public Use Microdata Areas Labels]
block_group_geoservice = acs.mapservice.layers[8]
block_group_geoservice
(ESRILayer) Census Block Groups
We'll use a SQL "where" clause to select only the state and county we need
block_group_geoservice.variables
| name | type | alias | domain | length | |
|---|---|---|---|---|---|
| 0 | OBJECTID | esriFieldTypeOID | OBJECTID | None | NaN |
| 1 | AREALAND | esriFieldTypeDouble | AREALAND | None | NaN |
| 2 | ALANDHIST | esriFieldTypeDouble | ALANDHIST | None | NaN |
| 3 | AREAWATER | esriFieldTypeDouble | AREAWATER | None | NaN |
| 4 | AWATERHIST | esriFieldTypeDouble | AWATERHIST | None | NaN |
| 5 | BLKGRP | esriFieldTypeString | BLKGRP | None | 1.0 |
| 6 | COUNTY | esriFieldTypeString | COUNTY | None | 3.0 |
| 7 | EFFDATE | esriFieldTypeDate | EFFDATE | None | 8.0 |
| 8 | ESTABDATE | esriFieldTypeDate | ESTABDATE | None | 8.0 |
| 9 | FUNCSTAT | esriFieldTypeString | FUNCSTAT | None | 1.0 |
| 10 | GEOID | esriFieldTypeString | GEOID | None | 12.0 |
| 11 | LSADC | esriFieldTypeString | LSADC | None | 2.0 |
| 12 | MTFCC | esriFieldTypeString | MTFCC | None | 5.0 |
| 13 | BASENAME | esriFieldTypeString | BASENAME | None | 100.0 |
| 14 | NAME | esriFieldTypeString | NAME | None | 100.0 |
| 15 | OID | esriFieldTypeString | OID | None | 22.0 |
| 16 | STATE | esriFieldTypeString | STATE | None | 2.0 |
| 17 | TRACT | esriFieldTypeString | TRACT | None | 6.0 |
| 18 | UR | esriFieldTypeString | UR | None | 1.0 |
| 19 | VINTAGE | esriFieldTypeString | VINTAGE | None | 2.0 |
| 20 | CENTLON | esriFieldTypeString | CENTLON | None | 12.0 |
| 21 | CENTLAT | esriFieldTypeString | CENTLAT | None | 11.0 |
| 22 | INTPTLON | esriFieldTypeString | INTPTLON | None | 12.0 |
| 23 | INTPTLAT | esriFieldTypeString | INTPTLAT | None | 11.0 |
| 24 | HU100 | esriFieldTypeDouble | HU100 | None | NaN |
| 25 | POP100 | esriFieldTypeDouble | POP100 | None | NaN |
| 26 | STGEOMETRY | esriFieldTypeGeometry | STGEOMETRY | None | NaN |
| 27 | STGEOMETRY.AREA | esriFieldTypeDouble | STGEOMETRY.AREA | None | NaN |
| 28 | STGEOMETRY.LEN | esriFieldTypeDouble | STGEOMETRY.LEN | None | NaN |
Use esri2gpd to load the data
# The base url for the map service API endpoint
block_group_geoservice._baseurl
'http://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Census2020/MapServer/8'
## We're just querying a GeoService — let's use esri2gpd
# Only Philadelphia
where_clause = "STATE = '42' AND COUNTY = '101'"
# Query
philly_block_groups = esri2gpd.get(block_group_geoservice._baseurl, where=where_clause)
len(philly_block_groups)
1338
philly_block_groups.head()
| geometry | OBJECTID | AREALAND | ALANDHIST | AREAWATER | AWATERHIST | BLKGRP | COUNTY | EFFDATE | ESTABDATE | FUNCSTAT | GEOID | LSADC | MTFCC | BASENAME | NAME | OID | STATE | TRACT | UR | VINTAGE | CENTLON | CENTLAT | INTPTLON | INTPTLAT | HU100 | POP100 | STGEOMETRY.AREA | STGEOMETRY.LEN | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POLYGON ((-75.05449 40.02465, -75.05405 40.02413, -75.05383 40.02388, -75.05360 40.02362, -75.05337 40.02336, -75.05315 40.02310, -75.05293 40.02286, -75.05270 40.02259, -75.05248 40.02235, -75.05... | 82 | 305092 | 305092 | 0 | 0 | 3 | 101 | NaN | NaN | S | 421010323003 | BG | G5030 | 3 | Block Group 3 | 208703717019554 | 42 | 032300 | None | 70 | -075.0499467 | +40.0222676 | -075.0499467 | +40.0222676 | 744 | 1869 | 520848.611219 | 3194.678561 |
| 1 | POLYGON ((-75.15987 39.94454, -75.15998 39.94401, -75.15841 39.94381, -75.15762 39.94372, -75.15684 39.94361, -75.15676 39.94396, -75.15673 39.94412, -75.15664 39.94451, -75.15654 39.94499, -75.15... | 83 | 70896 | 70896 | 0 | 0 | 1 | 101 | NaN | NaN | S | 421010011021 | BG | G5030 | 1 | Block Group 1 | 208703717019574 | 42 | 001102 | None | 70 | -075.1581610 | +39.9449699 | -075.1581610 | +39.9449699 | 1180 | 1729 | 120760.631816 | 1390.110306 |
| 2 | POLYGON ((-75.00180 40.10493, -75.00165 40.10480, -75.00150 40.10468, -75.00137 40.10456, -75.00134 40.10447, -74.99980 40.10324, -74.99901 40.10258, -74.99873 40.10231, -74.99838 40.10185, -74.99... | 904 | 423561 | 417638 | 0 | 0 | 2 | 101 | NaN | NaN | S | 421010361002 | BG | G5030 | 2 | Block Group 2 | 20870508933460 | 42 | 036100 | None | 70 | -074.9965242 | +40.1037503 | -074.9965242 | +40.1037503 | 404 | 1134 | 724822.503578 | 3558.455582 |
| 3 | POLYGON ((-75.15255 40.00318, -75.15293 40.00159, -75.15163 40.00143, -75.15071 40.00131, -75.14992 40.00121, -75.14915 40.00110, -75.14874 40.00105, -75.14815 40.00099, -75.14847 40.00177, -75.14... | 920 | 192284 | 192284 | 0 | 0 | 2 | 101 | NaN | NaN | S | 421010200002 | BG | G5030 | 2 | Block Group 2 | 208703717019432 | 42 | 020000 | None | 70 | -075.1507409 | +40.0042065 | -075.1507409 | +40.0042065 | 497 | 747 | 328094.605123 | 3138.906384 |
| 4 | POLYGON ((-75.15216 40.01254, -75.15189 40.01199, -75.15143 40.01090, -75.15107 40.01004, -75.15103 40.00990, -75.15100 40.00982, -75.15081 40.00920, -75.15046 40.00806, -75.15029 40.00750, -75.14... | 921 | 212571 | 212571 | 0 | 0 | 1 | 101 | NaN | NaN | S | 421010203001 | BG | G5030 | 1 | Block Group 1 | 208703717019433 | 42 | 020300 | None | 70 | -075.1492793 | +40.0091183 | -075.1492793 | +40.0091183 | 704 | 1354 | 362759.782648 | 3386.729282 |
Merge based on multiple columns: state, county, tract, and block group IDs.
The relevant columns are:
philly_demo_final = philly_block_groups.merge(
philly_demo_data,
left_on=["STATE", "COUNTY", "TRACT", "BLKGRP"],
right_on=["state", "county", "tract", "block group"],
)
philly_demo_final.head()
| geometry | OBJECTID | AREALAND | ALANDHIST | AREAWATER | AWATERHIST | BLKGRP | COUNTY | EFFDATE | ESTABDATE | FUNCSTAT | GEOID | LSADC | MTFCC | BASENAME | NAME_x | OID | STATE | TRACT | UR | VINTAGE | CENTLON | CENTLAT | INTPTLON | INTPTLAT | HU100 | POP100 | STGEOMETRY.AREA | STGEOMETRY.LEN | NAME_y | B03002_001E | B03002_003E | B03002_004E | B03002_005E | B03002_006E | B03002_007E | B03002_008E | B03002_009E | B03002_012E | state | county | tract | block group | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | POLYGON ((-75.05449 40.02465, -75.05405 40.02413, -75.05383 40.02388, -75.05360 40.02362, -75.05337 40.02336, -75.05315 40.02310, -75.05293 40.02286, -75.05270 40.02259, -75.05248 40.02235, -75.05... | 82 | 305092 | 305092 | 0 | 0 | 3 | 101 | NaN | NaN | S | 421010323003 | BG | G5030 | 3 | Block Group 3 | 208703717019554 | 42 | 032300 | None | 70 | -075.0499467 | +40.0222676 | -075.0499467 | +40.0222676 | 744 | 1869 | 520848.611219 | 3194.678561 | Block Group 3, Census Tract 323, Philadelphia County, Pennsylvania | 1537.0 | 744.0 | 439.0 | 0.0 | 0.0 | 0.0 | 0.0 | 22.0 | 332.0 | 42 | 101 | 032300 | 3 |
| 1 | POLYGON ((-75.15987 39.94454, -75.15998 39.94401, -75.15841 39.94381, -75.15762 39.94372, -75.15684 39.94361, -75.15676 39.94396, -75.15673 39.94412, -75.15664 39.94451, -75.15654 39.94499, -75.15... | 83 | 70896 | 70896 | 0 | 0 | 1 | 101 | NaN | NaN | S | 421010011021 | BG | G5030 | 1 | Block Group 1 | 208703717019574 | 42 | 001102 | None | 70 | -075.1581610 | +39.9449699 | -075.1581610 | +39.9449699 | 1180 | 1729 | 120760.631816 | 1390.110306 | Block Group 1, Census Tract 11.02, Philadelphia County, Pennsylvania | 1742.0 | 1371.0 | 84.0 | 0.0 | 186.0 | 0.0 | 0.0 | 82.0 | 19.0 | 42 | 101 | 001102 | 1 |
| 2 | POLYGON ((-75.00180 40.10493, -75.00165 40.10480, -75.00150 40.10468, -75.00137 40.10456, -75.00134 40.10447, -74.99980 40.10324, -74.99901 40.10258, -74.99873 40.10231, -74.99838 40.10185, -74.99... | 904 | 423561 | 417638 | 0 | 0 | 2 | 101 | NaN | NaN | S | 421010361002 | BG | G5030 | 2 | Block Group 2 | 20870508933460 | 42 | 036100 | None | 70 | -074.9965242 | +40.1037503 | -074.9965242 | +40.1037503 | 404 | 1134 | 724822.503578 | 3558.455582 | Block Group 2, Census Tract 361, Philadelphia County, Pennsylvania | 935.0 | 802.0 | 7.0 | 0.0 | 97.0 | 0.0 | 0.0 | 0.0 | 29.0 | 42 | 101 | 036100 | 2 |
| 3 | POLYGON ((-75.15255 40.00318, -75.15293 40.00159, -75.15163 40.00143, -75.15071 40.00131, -75.14992 40.00121, -75.14915 40.00110, -75.14874 40.00105, -75.14815 40.00099, -75.14847 40.00177, -75.14... | 920 | 192284 | 192284 | 0 | 0 | 2 | 101 | NaN | NaN | S | 421010200002 | BG | G5030 | 2 | Block Group 2 | 208703717019432 | 42 | 020000 | None | 70 | -075.1507409 | +40.0042065 | -075.1507409 | +40.0042065 | 497 | 747 | 328094.605123 | 3138.906384 | Block Group 2, Census Tract 200, Philadelphia County, Pennsylvania | 976.0 | 101.0 | 722.0 | 0.0 | 10.0 | 0.0 | 0.0 | 0.0 | 143.0 | 42 | 101 | 020000 | 2 |
| 4 | POLYGON ((-75.15216 40.01254, -75.15189 40.01199, -75.15143 40.01090, -75.15107 40.01004, -75.15103 40.00990, -75.15100 40.00982, -75.15081 40.00920, -75.15046 40.00806, -75.15029 40.00750, -75.14... | 921 | 212571 | 212571 | 0 | 0 | 1 | 101 | NaN | NaN | S | 421010203001 | BG | G5030 | 1 | Block Group 1 | 208703717019433 | 42 | 020300 | None | 70 | -075.1492793 | +40.0091183 | -075.1492793 | +40.0091183 | 704 | 1354 | 362759.782648 | 3386.729282 | Block Group 1, Census Tract 203, Philadelphia County, Pennsylvania | 1519.0 | 13.0 | 1467.0 | 0.0 | 12.0 | 0.0 | 0.0 | 0.0 | 27.0 | 42 | 101 | 020300 | 1 |
Using geopandas...
# Check the CRS
philly_demo_final.crs
<Geographic 2D CRS: EPSG:4326> Name: WGS 84 Axis Info [ellipsoidal]: - Lat[north]: Geodetic latitude (degree) - Lon[east]: Geodetic longitude (degree) Area of Use: - name: World. - bounds: (-180.0, -90.0, 180.0, 90.0) Datum: World Geodetic System 1984 ensemble - Ellipsoid: WGS 84 - Prime Meridian: Greenwich
fig, ax = plt.subplots(figsize=(10,10))
# Plot the choropleth
philly_demo_final.plot(ax=ax, column='B03002_001E', legend=True)
# Format
ax.set_title("Population of Philadelphia by Block Group", fontsize=16)
ax.set_axis_off()
Or using hvplot...
cols = ['NAME_x', 'B03002_001E', 'geometry']
philly_demo_final[cols].hvplot(c='B03002_001E',
geo=True,
legend=True,
width=600,
height=400,
cmap='viridis',
frame_height=800,
frame_width=800,
hover_cols=["NAME_x"])
# Rename columns
philly_demo_final = philly_demo_final.rename(
columns={
"B03002_001E": "Total", # Total
"B03002_003E": "White", # Not Hispanic, White
"B03002_004E": "Black", # Not Hispanic, Black
"B03002_005E": "AI/AN", # Not Hispanic, American Indian
"B03002_006E": "Asian", # Not Hispanic, Asian
"B03002_007E": "NH/PI", # Not Hispanic, Native Hawaiian
"B03002_008E": "Other_", # Not Hispanic, Other
"B03002_009E": "Two Plus", # Not Hispanic, Two or More Races
"B03002_012E": "Hispanic", # Hispanic
}
)
# Add an "Other" column
cols = ['AI/AN', 'NH/PI','Other_', 'Two Plus']
philly_demo_final['Other'] = philly_demo_final[cols].sum(axis=1)
Given a polygon, create randomly distributed points that fall within the polygon.
def random_points_in_polygon(number, polygon):
"""
Generate a random number of points within the
specified polygon.
"""
points = []
min_x, min_y, max_x, max_y = polygon.bounds
i= 0
while i < number:
point = Point(np.random.uniform(min_x, max_x), np.random.uniform(min_y, max_y))
if polygon.contains(point):
points.append(point)
i += 1
return points
Random points example
# get the first block group polygon in the data set
geo = philly_demo_final.iloc[0].geometry
geo
fig, ax = plt.subplots(figsize=(6, 6))
# Generate some random points
random_points = random_points_in_polygon(100, geo)
# Plot random points
gpd.GeoSeries(random_points).plot(ax=ax, markersize=20, color="red")
# Plot boundary of block group
gpd.GeoSeries([geo]).plot(ax=ax, facecolor="none", edgecolor="black")
ax.set_axis_off()
def generate_dot_map(data, people_per_dot):
"""
Given a GeoDataFrame with demographic columns, generate a dot
map according to the population in each geometry.
"""
results = []
for field in ["White", "Hispanic", "Black", "Asian", "Other"]:
# generate random points
pts = data.apply(
lambda row: random_points_in_polygon(
row[field] / people_per_dot, row["geometry"]
),
axis=1,
)
# combine into single GeoSeries
pts = gpd.GeoSeries(pts.apply(pd.Series).stack(), dtype=object, crs=data["geometry"].crs)
pts.name = "geometry"
# make into a GeoDataFrame
pts = gpd.GeoDataFrame(pts)
pts["field"] = field
# save
results.append(pts)
return gpd.GeoDataFrame(pd.concat(results), crs=data["geometry"].crs).reset_index(
drop=True
)
dot_map = generate_dot_map(philly_demo_final, people_per_dot=50)
/Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/pandas/core/dtypes/cast.py:122: ShapelyDeprecationWarning: The array interface is deprecated and will no longer work in Shapely 2.0. Convert the '.coords' to a numpy array instead. arr = construct_1d_object_array_from_listlike(values) /var/folders/49/ntrr94q12xd4rq8hqdnx96gm0000gn/T/ipykernel_53673/2645225740.py:18: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning. pts = gpd.GeoSeries(pts.apply(pd.Series).stack(), dtype=object, crs=data["geometry"].crs) /Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/pandas/core/dtypes/cast.py:122: ShapelyDeprecationWarning: The array interface is deprecated and will no longer work in Shapely 2.0. Convert the '.coords' to a numpy array instead. arr = construct_1d_object_array_from_listlike(values) /var/folders/49/ntrr94q12xd4rq8hqdnx96gm0000gn/T/ipykernel_53673/2645225740.py:18: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning. pts = gpd.GeoSeries(pts.apply(pd.Series).stack(), dtype=object, crs=data["geometry"].crs) /Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/pandas/core/dtypes/cast.py:122: ShapelyDeprecationWarning: The array interface is deprecated and will no longer work in Shapely 2.0. Convert the '.coords' to a numpy array instead. arr = construct_1d_object_array_from_listlike(values) /var/folders/49/ntrr94q12xd4rq8hqdnx96gm0000gn/T/ipykernel_53673/2645225740.py:18: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning. pts = gpd.GeoSeries(pts.apply(pd.Series).stack(), dtype=object, crs=data["geometry"].crs) /var/folders/49/ntrr94q12xd4rq8hqdnx96gm0000gn/T/ipykernel_53673/2645225740.py:18: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning. pts = gpd.GeoSeries(pts.apply(pd.Series).stack(), dtype=object, crs=data["geometry"].crs) /Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/pandas/core/dtypes/cast.py:122: ShapelyDeprecationWarning: The array interface is deprecated and will no longer work in Shapely 2.0. Convert the '.coords' to a numpy array instead. arr = construct_1d_object_array_from_listlike(values) /Users/nhand/mambaforge/envs/musa-550-fall-2022/lib/python3.9/site-packages/pandas/core/dtypes/cast.py:122: ShapelyDeprecationWarning: The array interface is deprecated and will no longer work in Shapely 2.0. Convert the '.coords' to a numpy array instead. arr = construct_1d_object_array_from_listlike(values) /var/folders/49/ntrr94q12xd4rq8hqdnx96gm0000gn/T/ipykernel_53673/2645225740.py:18: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning. pts = gpd.GeoSeries(pts.apply(pd.Series).stack(), dtype=object, crs=data["geometry"].crs)
print("number of points = ", len(dot_map))
number of points = 34143
dot_map.tail()
| geometry | field | |
|---|---|---|
| 34138 | POINT (-75.08299 40.01867) | Other |
| 34139 | POINT (-75.24638 39.96198) | Other |
| 34140 | POINT (-75.08122 40.02797) | Other |
| 34141 | POINT (-75.05724 40.01659) | Other |
| 34142 | POINT (-75.21985 39.93105) | Other |
# setup a custom color map from ColorBrewer
from matplotlib.colors import ListedColormap
cmap = ListedColormap(
["#3a833c", "#377eb8", "#4daf4a", "#984ea3", "#ff7f00", "#ffff33"]
)
# Convert to 3857
dot_map_3857 = dot_map.to_crs(epsg=3857)
# Initialize the figure and axes
fig, ax = plt.subplots(figsize=(10, 10), facecolor="#cfcfcf")
# Plot
dot_map_3857.plot(
ax=ax,
column="field",
categorical=True,
legend=True,
alpha=1,
markersize=0.5,
cmap=cmap,
)
# format
ax.set_title("Philadelphia, PA", fontsize=16)
ax.text(
0.5, 0.95, "1 dot = 50 people", fontsize=12, transform=ax.transAxes, ha="center"
)
ax.set_axis_off()
Let's use demographic census data in Philadelphia by census tract and compare to a dataset of childhood lead poisoning.
* operator to get all tracts in Philadelphia county
Add a new column to your data called percent_black.
Important: Make sure you convert the data to floats!
carto2gpd package
See the .dropna() function and the subset= keyword.
census_tract and GEOID fieldsGeoDataFrame.merge(...)
We only need the 'geometry', 'percent_black', and 'perc_5plus', and 'NAME' columns
Make two plots:
You can make these using hvplot or geopandas/matplotlib — whichever you prefer!
In the previous plots, it's still hard to see the relationship. Use the kdeplot() function in seaborn to better visualize the relationship.
You will need to remove any NaN entries first.
You should see two peaks in the distribution clearly now!